DBMS_METADATA.GET_DDL Table
Get Table DDL To retrieve the definition (Data Definition Language, DDL) of a table, we use the function DBMS_METADATA.GET_DDL to make it. Let's see an… Read More »DBMS_METADATA.GET_DDL Table
Data Definition Language (DDL)
LAST_DDL_TIME was Changed, Why?
What is LAST_DDL_TIME? Generally speaking, LAST_DDL_TIME means the last change date time of the object definition, all by Data Definition Language (DDL). But sometimes, it's… Read More »LAST_DDL_TIME was Changed, Why?
How to Resolve Toad Error ORA-00904: "REF": invalid identifier
Tried to display "Script" (DDL) of a table in Toad for Oracle, we saw ORA-00904: "REF": invalid identifier. Typically, ORA-00904 is an unmatched column issue,… Read More »How to Resolve Toad Error ORA-00904: "REF": invalid identifier
How to Get DDL of Sequence from ALL_SEQUENCES
You don't have to export and import sequences by data pump, you can compose the creation statements by querying ALL_SEQUENCES: [oracle@primary01 oracle]$ vi compose_create_sequence.sql set… Read More »How to Get DDL of Sequence from ALL_SEQUENCES
How to Get DDL of Synonym from ALL_SYNONYMS
You don't have to export and import public synonyms by data pump, you can compose the creation statements by querying ALL_SYNONYMS:: [oracle@primary01 oracle]$ vi compose_create_or_replace_synonym.sql… Read More »How to Get DDL of Synonym from ALL_SYNONYMS
How to Generate Tablespace DDL with Uniform Rules
In the beginning of data migration, we usually recreate some tablespaces to accommodate data from the source. The best way to do this is to… Read More »How to Generate Tablespace DDL with Uniform Rules
Truncate vs Delete
Truncate vs Delete Here I compare the differences between TRUNCATE and DELETE an entire table in the following chart. Question Truncate Table Delete From DDL… Read More »Truncate vs Delete
DB Link, How and Why
What is DB Link? A database link is a kind of schema object in a database that enables users to access and manipulate objects on… Read More »DB Link, How and Why
4 Types of SQL Languages in RDBMS
Types of SQL Statements SQL statements in relational database management system (RDBMS) could sometimes be too complicated to be analyzed for. As SQL developers, we… Read More »4 Types of SQL Languages in RDBMS
How to Resolve ORA-02494: invalid or missing maximum file size in MAXSIZE clause
Generated DDL from tools may not be executable sometimes. I got ORA-02494 when I execute DDL scripts that were generated from other database by TOAD,… Read More »How to Resolve ORA-02494: invalid or missing maximum file size in MAXSIZE clause