Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [data-dictionary]

The tag has no usage guidance.

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

Temporary table information left over on InnoDB data dictionary after a db crash while a alter table was runnig

After a database crash while the system was running an alter table command I'm getting the following message during mysqld initialization: 2024-02-25 19:58:48 7fa2f9e84880 InnoDB: Operating system ...
Vaiks's user avatar
  • 1
1 vote
0 answers
32 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 ...
White Owl's user avatar
  • 795
0 votes
1 answer
208 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 ...
Atilla Ozgur's user avatar
  • 1,456
-1 votes
2 answers
42 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 ...
AnTiCoD's user avatar
0 votes
0 answers
154 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 ...
Nasrudeen's user avatar
  • 101
-2 votes
1 answer
1k 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; ...
Astora's user avatar
  • 723
0 votes
1 answer
663 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 ...
Jeff's user avatar
  • 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, ...
Mikhail Aksenov's user avatar
0 votes
1 answer
150 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 ...
cna's user avatar
  • 101
0 votes
1 answer
451 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 ...
user11969413's user avatar
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 ...
Just a learner's user avatar
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 ---...
DrLou's user avatar
  • 121
12 votes
4 answers
13k 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 ...
ConanTheGerbil's user avatar
0 votes
2 answers
4k 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 ...
Rahman Gurbaz's user avatar
1 vote
3 answers
688 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 ...
Athafoud's user avatar
  • 186
2 votes
1 answer
112 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?
johnsod0's user avatar
0 votes
1 answer
439 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 ...
Pierre's user avatar
  • 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 ...
Green_Sam's user avatar
1 vote
0 answers
246 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 ...
René Nyffenegger's user avatar
1 vote
1 answer
747 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; ...
Jon Heller's user avatar