Questions tagged [data-dictionary]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
22 views

Trying to write recursive query to get list of tables by foreign key

I am using this query to purge data from the bottom of the tree up. This is just the first step in my process. Does anyone have any suggestions on how to handle the recursion? Thanks DROP TABLE IF ...
0
votes
1answer
27 views

Data Lake : Data Catalog and Data Schema definitions

I'm trying to understand the definition of data catalog and data schema. After several articles I read, I'm getting even more confused! I realized when the article is talking about data lake, the ...
0
votes
1answer
94 views

InnoDB Data Dictionary Cleanup for a Non-Existent Database Named “tmp”?

I have a number of error messages like this in my error.log file referencing different files that can't be opened when I start my mariadb 10.4.8 server: 2019-09-30 17:38:19 0 [ERROR] InnoDB: Cannot ...
0
votes
1answer
104 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
2answers
884 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 ---...
2
votes
2answers
2k 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
2answers
379 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
413 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
83 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
114 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
2k 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
104 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
547 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; ...