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
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
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)
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 ...
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