DDL

How to Resolve ORA-00940: invalid ALTER command

by Ed Chen
September 8, 2021September 2, 2021

ORA-00940 ORA-00940 means that you use an invalid object type for ALTER operation, usually it's because you misspelled the object type name. First of all,… Read More »

How to Generate Tablespace DDL with Uniform Rules

by Ed Chen
December 9, 2020March 28, 2021

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 »

Oracle DROP INDEX Syntax for All Releases

by Ed Chen
July 4, 2020January 23, 2021

Here is the list of DROP INDEX Syntax for All Releases of Oracle Database. DROP INDEX Syntax for Oracle Database 21c DROP INDEX Syntax for… Read More »

Oracle ALTER INDEX Syntax for All Releases

by Ed Chen
July 4, 2020January 23, 2021

Here is the list of ALTER INDEX Syntax for All Releases of Oracle Database. ALTER INDEX syntax for Oracle Database 21c ALTER INDEX syntax for… Read More »

Oracle CREATE INDEX Syntax for All Releases

by Ed Chen
July 4, 2020January 23, 2021

Here is the list of CREATE INDEX Syntax for All Releases of Oracle Database. CREATE INDEX Syntax for Oracle Database 21c CREATE INDEX Syntax for… Read More »

Oracle ALTER TABLE Syntax for All Releases

by Ed Chen
July 1, 2020January 23, 2021

Here is the list of ALTER TABLE Syntax for All Releases of Oracle Database. ALTER TABLE syntax for Oracle Database 21c ALTER TABLE syntax for… Read More »

Oracle CREATE TABLE Syntax for All Releases

by Ed Chen
July 1, 2020January 23, 2021

Here is the list of CREATE TABLE Syntax for All Releases of Oracle Database. CREATE TABLE Syntax for Oracle Database 21c CREATE TABLE Syntax for… Read More »

Oracle DROP TABLE Syntax for All Releases

by Ed Chen
July 1, 2020January 23, 2021

Here is the list of DROP TABLE Syntax for All Releases of Oracle Database. DROP TABLE Syntax for Oracle Database 21c DROP TABLE Syntax for… Read More »

How to Export Column Comment DDL

by Ed Chen
February 22, 2019December 28, 2020

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 Resolve OGG-00519 REPLICAT DDL Errors in GoldenGate

by Ed Chen
September 2, 2017January 20, 2021
3 Comments

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 »