No question at this time
DBA Top 10
1 A. Kavsek 8600
2 M. Cadot 7000
3 B. Vroman 6000
4 T. Boles 4550
5 J. Schnackenberg 4100
6 P. Wisse 3000
7 T. P 1200
8 G. Lambregts 1100
8 . Lauri 1100
10 R. Pattyn 800
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48373
Total active users1542
Act. users last 24h9
Act. users last hour1
Registered user hits last week188
Registered user hits last month1051
Go up

Synonym ALL_GSPACE
Next thread: Automatic SQL plan baseline and Resource manager
Prev thread: Need Advise on Partition Maintenance

Message Score Author Date
Hi, I have found the public synonym ALL_GSPACE ...... Lauri Feb 26, 2019, 14:00
And what is SYSTEM.ALL_GSPACE? Regards Miche...... Michel Cadot Feb 26, 2019, 14:35
That object is not part of the Oracle database.... Gareth Graham Feb 26, 2019, 14:47
@Michel: About: And what is SYSTEM.ALL_GSPACE? ...... Lauri Feb 26, 2019, 14:59
Of ALL_GSPACE is an object, the questions was wh...... Michel Cadot Feb 26, 2019, 15:08
SELECT object_type FROM dba_objects WHERE owner=...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Gareth Graham Feb 26, 2019, 16:12
@Michel: This object is in fact a view owned by S...... Lauri Feb 26, 2019, 16:24
They have been. They should not have been made wit...... Gareth Graham Feb 26, 2019, 16:38

Follow up by mail Click here


Subject: Synonym ALL_GSPACE
Author: Lauri, Netherlands
Date: Feb 26, 2019, 14:00, 84 days ago
Os info: all
Oracle info: 12c
Error info: N/A
Message: Hi,

I have found the public synonym ALL_GSPACE created on SYSTEM.ALL_GSPACE in one of the Oracle 12c database of a customer.
I didn't find it mentioned in the Oracle documentation.
Does someone know if this is an object part of the Oracle software.

Kind Regards,

Lauri
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Synonym ALL_GSPACE
Author: Michel Cadot, France
Date: Feb 26, 2019, 14:35, 84 days ago
Message:
And what is SYSTEM.ALL_GSPACE?

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Synonym ALL_GSPACE
Author: Gareth Graham, United Kingdom
Date: Feb 26, 2019, 14:47, 84 days ago
Message: That object is not part of the Oracle database.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re-Synonym ALL_GSPACE
Author: Lauri, Netherlands
Date: Feb 26, 2019, 14:59, 84 days ago
Message: @Michel:
About: And what is SYSTEM.ALL_GSPACE?
SYSTEM -> the owner of the object
ALL_GSPACE -> the object
That's what I can see when I query all_synonyms.

@Gareth:
I suspected this object is not part of the original RDBMS, but has been created later under the SYSTEM user...

Kind Regards,

Lauri
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Re-Synonym ALL_GSPACE
Author: Michel Cadot, France
Date: Feb 26, 2019, 15:08, 84 days ago
Message:
Of ALL_GSPACE is an object, the questions was what kind of object? What is its definition?

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Re-Synonym ALL_GSPACE
Author: Gareth Graham, United Kingdom
Date: Feb 26, 2019, 16:12, 84 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: SELECT object_type
FROM dba_objects
WHERE owner='SYSTEM' AND object_name='ALL_GSPACE';

Then:

SELECT DBMS_METADATA.GET_DDL('<object_type>','ALL_GSPACE','SYSTEM') FROM DUAL;
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re-Synonym ALL_GSPACE
Author: Lauri, Netherlands
Date: Feb 26, 2019, 16:24, 84 days ago
Message: @Michel:
This object is in fact a view owned by SYSTEM.
It is a view created againt two other tables or views: system.pid_tot_space and system.pid_free_space.
I have never heard about database objects like system.pid_tot_space or system.pid_free_space.
The more I think, the more I believe they have been created after the database installation.

Kind Regards
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Re-Synonym ALL_GSPACE
Author: Gareth Graham, United Kingdom
Date: Feb 26, 2019, 16:38, 84 days ago
Message: They have been. They should not have been made with the SYSTEM user though.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here