How to Export Column Comment DDL
Column Comment DDL During metadata migration, I found all column comments with multi-byte characters are garbled. So what I was going to do next is… Read More »How to Export Column Comment DDL
DDL
How to Resolve OGG-00519 REPLICAT DDL Errors in GoldenGate
OGG-00519 In the remote database, you may not create all objects to resolve dependency problems. Here are some OGG-00519 DDL errors in REPLICAT report below:… Read More »How to Resolve OGG-00519 REPLICAT DDL Errors in GoldenGate
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
How to Get Tablespace Definition (DDL)
We can compose the execution statement for getting the definition of all tablespaces by the following.SQL> select 'exec dbms_output.put_line(dbms_metadata.get_ddl(''TABLESPACE'',''' || tablespace_name || '''));' ddl from… Read More »How to Get Tablespace Definition (DDL)
You Cannot Resize a DataFile in "ALTER TABLESPACE" Except ...
According to SQL syntax of Oracle database, you can't resize the data files by using ALTER TABLESPACE except the tablespace was created as BIGFILE, but… Read More »You Cannot Resize a DataFile in "ALTER TABLESPACE" Except ...
The Default Values in "ALTER SYSTEM SET" Statement
Without declaring SCOPEIf you do not specify this clause, then:If a server parameter file was used to start up the database, then BOTH is the… Read More »The Default Values in "ALTER SYSTEM SET" Statement