Stack Overflow
Stack Overflow

Questions tagged [data-dictionary]

A Data Dictionary stores information about all user-defined objects in the database. It usually comes with utilities to cross-reference all system components to each other.

References

187 questions
1
vote
1 answer

In Oracle 19c database, how can I find out tablespace, schema, tables allowed to access, privileges assigned to a user grouping by that username?

In Oracle 19c database, how can I find out tablespace, schema, tables allowed to access, privileges assigned to a user grouping by that username ?
zafar
  • 44
  • 4
1
vote
1 answer

What default system tables are available on Informix 9.53C1?

I'm looking for the data dictionary for Informix 9.53C1 system tables/catalog. I've found a couple sites that show some of these tables, but I couldn't find a full, comprehensive list of all system tables and their…
CheeseConQueso
  • 5,831
  • 29
  • 93
  • 126
1
vote
0 answers

Excluding CSV Columns from Data Dictionary

I am attempting to create a data dictionary that does not include all of the columns in the source csv file. I have managed to create one that does include all the columns, but want to exclude some of them. The code I am using is this: input_file =…
Dommi24
  • 11
  • 1
1
vote
2 answers

How to access data dictionary from another class?

I have a class called "program" and a data dictionary called "mydic" in this class. Then I tried to write all data from "mydic" dictionary to a file name "expenses.txt". After that, I created another class called "Total_Expenses" that inherit from a…
Alice
  • 65
  • 6
1
vote
1 answer

Convert data dictionary from word to excel with R

I got the data dictionary from data provider which contains hundreds vars in different word files and looks like this: In order to add this dictionary to my current dataset, I need to convert it to certain format in Excel. For example,for first…
Rstudyer
  • 309
  • 1
  • 8
1
vote
1 answer

csv.reader reports values out of range

I am attempting to convert a csv file into a python data dictionary. Here my code: import csv picset = Set_1 with open('/Users/vp_enc_' + str(picset) + '_eeg_trigger_codes.csv', mode='r') as f: reader = csv.reader(f) triggerdict =…
arkadiy
  • 746
  • 1
  • 10
  • 26
1
vote
1 answer

How to effectively append datasets using a dictionary (with R/dplyr)? / How to coalesce 'all columns with duplicate names'?

I have a series of data sets and a dictionary to bring these together. But I'm struggling to figure out how to automate this. Suppose this data and dictionary (actual one is much longer, thus I want to automate): mtcarsA <- mtcars[1:5,] %>%…
daaronr
  • 507
  • 1
  • 4
  • 12
1
vote
1 answer

Data Dictionary for NoSQL Database

Let say, I'm using Firebase Cloud Firestore, which is a NoSQL database. Example of database content is as follows: - customers - customer_01 - name: "abc" - email: "abc@gmail.com" - customer_02 - name: "bcd" - email:…
a..
  • 109
  • 13
1
vote
1 answer

How to find which column has which LOB attached in Oracle12c XMLTYPE column?

I have below table with two XMLTYPE Columns (ERROR_FLAG , COL_XML ) and One LOB Column (LOG_TEXT ) CREATE TABLE APPLICATION_LOG ( ID NUMBER NOT NULL, LOG_TIME TIMESTAMP(6) …
kritika arora
  • 55
  • 1
  • 4
1
vote
2 answers

DB2 (AS400/ i Series) column value description

I found a query online which helps me get all the column names along with the column description, which I have pasted below. Select SYSTEM_TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, varchar(COLUMN_TEXT, 50) As COLUMN_DESC From QSYS2.syscolumns WHERE…
kk1791
  • 11
  • 5
1
vote
2 answers

User_tables updates when adding a table

Why when I add a table to my user I see it in the user_tables table. I’m asking it because this table is a data dictionary table and it should be static and updated only when the DB is starting, while the dynamic performance views are updating while…
itaiman5
  • 41
  • 1
  • 1
  • 2
1
vote
3 answers

Is there a way to search in Oracle using a string if you don't know if the string is a schema/table/etc..?

I'm trying to search for something particular in the Oracle database, but I don't know if it is a table, or schema, or user, etc... Is there any command that allows to make a search for string if its type is unknown? For example: SQL> SHOW STRING…
Phillip
  • 43
  • 1
  • 12
1
vote
1 answer

dbms_metadata.get_ddl() failes on a schema different from current user in Oracle

I need to read the structure of some database objects from an oracle database. So I want to do the following: select dbms_metadata.get_ddl('TABLE', 'MY_TABLE', 'OTHERUSER') from dual That works well if I'm logged in with the OTHERUSER user. But…
Michael Baarz
  • 406
  • 5
  • 17
1
vote
2 answers

How To Kill Oracle DB Sessions Who are inActive Only?

I need to Terminate(kill ) All Sessions inside Oracle Db v$session where the status is not Active To list active and Inactive Sessions i used this statement: SELECT sid, serial#, status FROM v$session; I need a Statement to terminate Sessions where…
Mohammed Ali
  • 1,117
  • 1
  • 16
  • 31
1
vote
1 answer

How do you create a Reports diagram in Enterprise Architect?

I am trying to create a Reports diagram with a model document and report specification in Enterprise Architect. The embarrassing part of this is that I've done this before, but can't work out how I did it. And I didn't take notes which I probably…
Jay Cummins
  • 1,039
  • 2
  • 14
  • 31
1 2 3
…
12 13