Toad Create Table Example
How to create a table in Oracle step by step? To create a new table, we can choose to compose a hand-writing PL/SQL statement which… Read More »Toad Create Table Example
Data Definition Language (DDL)
PL/SQL Developer Create Table Example
How to create a new table in Oracle? To create a new table, we can choose to compose a hand-writing PL/SQL statement which may be… Read More »PL/SQL Developer Create Table Example
SQL Developer Create Table Example
How do I create a new table in Oracle? To create a new table, we can choose to compose a hand-writing SQL statement which may… Read More »SQL Developer Create Table Example
How to Resolve ORA-01466: unable to read data - table definition has changed
ORA-01466 Tried to perform a flashback query, but it failed with ORA-01466. SQL> select count(*) cnt from t1 as of timestamp to_timestamp('2023-02-19 22:15:00', 'yyyy-mm-dd hh24:mi:ss');… Read More »How to Resolve ORA-01466: unable to read data - table definition has changed
How Oracle Unlock Table
In this post, we'd like to talked about 2 topics: Lock Table Unlock Table Lock Table Oracle provides LOCK TABLE statements to let users lock… Read More »How Oracle Unlock Table
Create Table as Select (CTAS) to Tablespace
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
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
LAST_DDL_TIME, How and Why
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
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
Get DDL 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 »Get DDL from ALL_SEQUENCES