Questions tagged [data-dictionary]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
16 views

What privileges are need for a normal Oracle user to access V$ and DBA_ views?

I'm connecting to Oracle 19c as HR user. I want to execute the following SQL and some dba_... views: select s.sid ,s.serial# ,s.username ,s.machine ,s.status ,s.lockwait ...
0
votes
0answers
41 views

Use Thesaurus as Synonym Dictionary for FTS?

As I understood, the function of this dictionaries are the same, except that Synonyms Dict do not support operation with phrases. Is It OK to use one dictionary for thesaurus and phrases in ...
0
votes
2answers
194 views

PostgreSQL - how to generate an array containing column name and column data…?

I'd like to create a dictionary - an array - from a simple query, to include column names in output. IE, I'd like to turn this: SELECT id, last, first FROM names; id | last | first ---...
1
vote
2answers
750 views

How to identify the ranges over which a postgres table was partitioned?

If I create a table and partitions like this... CREATE TABLE tab1 (a int, b int) PARTITION BY RANGE(a); CREATE TABLE tab1_p1 PARTITION OF tab1 FOR VALUES FROM (0) TO (100); CREATE TABLE tab1_p2 ...
0
votes
1answer
60 views

Oracle user created information

Is it possible to determine what user created another user's account in Oracle database? I have two types of users in database: Users having system and object privileges Users having only system ...
1
vote
3answers
332 views

Does increased Data Dictionary size affects performance

As I understand, Data Dictionary Is a collection of tables, part of SYS schema (if not the whole SYS schema) It is stored as 'regular' tables, so whatever is applied to database tables, also ...
2
votes
1answer
54 views

what oracle data dictionary view can be used to decribe types defined in a plsql package?

What oracle data dictionary view can be used to describe types / subtypes defined in a plsql package?
0
votes
1answer
70 views

How to delete an unknown object?

I want to create a new stored procedure but I got this error: 00955. 00000 - "name is already used by an existing object" The problem is I don't remember to have created an object with this name ...
1
vote
2answers
1k views

Roles assigned to each user POSTGRES

i'm trying to make a query that shows the users and all the roles that they have, i already know how to ask about the roles of one particular user: SELECT oid, rolname FROM pg_roles WHERE ...
1
vote
0answers
87 views

Invalid views not showing in user_dependencies after first compilation

When I create an (invalid) view that selects from another invalid view, the view does not immediately show up in user_dependencies. I am wondering if this is expected. These are the steps to ...
1
vote
1answer
481 views

Recreate fixed views

Is it possible to recreate Oracle fixed views? I have a performance problem with GV$ACTIVE_SESSION_HISTORY that might require rebuilding the view. A simple select * from gv$active_session_history; ...