Questions tagged [data-dictionary]
The data-dictionary tag has no usage guidance.
19
questions
0
votes
0
answers
22
views
User types as foreign keys
Largely theoretical question or idea discussion
Lets say we have several simple dictionaries:
create table dic1(code integer primary key, description varchar(256));
create table dic2(code integer ...
- 645
0
votes
1
answer
130
views
How to replace LONG columns in Data Dictionary views in Oracle with varchar
This oracle forum posts in 2015 says that Long data type is deprecated for 20 years. Right now, in 2023, it is almost 30 years this data type is deprecated but it is commonly used in data dictionary ...
- 1,446
-1
votes
2
answers
29
views
Find in what table I can find multiple collumns
I am trying to write a query that will show me the tables that contains all the following columns: ProductGroup, ProductClass and ProductID.
But I am not very successful at it. Can somebody help me ...
- 1
0
votes
0
answers
144
views
Redshift PG_TABLE_DEF table listing unknown tables
When I count number of tables in my schema manually, it is 220.
When I count number of views in my schema manually, it is 23.
220 + 23 = 243
However, this query:
select count(distinct tablename) from ...
- 101
-2
votes
1
answer
881
views
How to find objects inside a tablespace without using DBA_SEGMENTS
DBA_SEGMENTS just shows objects that already have some associated extent (and so, it's considered a segment).
Demo
Creating a new tablespace:
SQL> create tablespace manu datafile size 20m;
...
- 630
0
votes
1
answer
529
views
Expressing A Composite Key in a Data Dictionary
I am looking for an example of expressing a "Composite Keys" in a data dictionary.
I am using an MSO Access application with a Lecturer Table and Subjects Table where I have taken the ...
- 1
2
votes
1
answer
1k
views
information_schema.columns slow performance
we have system that quite a lot and often asks database about:
SELECT TABLE_NAME, TABLE_SCHEMA, COLUMN_NAME, ORDINAL_POSITION, COLUMN_DEFAULT, NUMERIC_PRECISION, CHARACTER_MAXIMUM_LENGTH, ...
- 421
0
votes
1
answer
127
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 ...
- 101
0
votes
1
answer
425
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
1
answer
1k
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
...
- 2,602
0
votes
2
answers
4k
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
---...
- 111
10
votes
4
answers
11k
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 ...
- 1,125
0
votes
2
answers
3k
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
3
answers
659
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 ...
- 186
2
votes
1
answer
109
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?
- 15
0
votes
1
answer
402
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 ...
- 177
2
votes
2
answers
5k
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
...
- 33
1
vote
0
answers
226
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 ...
- 3,743
1
vote
1
answer
733
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; ...
- 512