Create Table as Select Tablespace Without specifying tablespace, Create Table as Select (CTAS) will go to the default tablespace of the user. How about specifying… Read More »Create Table as Select (CTAS) to Tablespace
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
LAST_DDL_TIME Generally speaking, LAST_DDL_TIME in ALL_OBJECTS or DBA_OBJECTS means that the last time of the object definition changed by Data Definition Language (DDL). But sometimes,… Read More »LAST_DDL_TIME, How and Why
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 »Get DDL from ALL_SEQUENCES
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 »Get DDL from ALL_SYNONYMS
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 in Oracle
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