Table of Contents Previous Next


3 Migrating a Database : 3.1 Schema Extraction

Please note: You must have SELECT CATALOG ROLE or SELECT ANY DICITIONARY privileges in the Oracle database.
2.
Connect to SQL*Plus with user having SELECT_CATALOG_ROLE and SELECT ANY DICTIONARY privileges and run the command:
SQL>@edb_ddl_extractor.sql
Enter SCHEMA NAME[S] (use ‘,’ delimiter for multiple schemas) to extract DDLs:
Enter the PATH to store DDL file: /home/oracle/extracted_ddls/
Enter SCHEMA NAME[S] (use ‘,’ delimiter for multiple schemas) to extract DDLs:
Enter the PATH to store DDL file: c\Users\Example\Desktop\
Please Note: You can also enter a single schema name.
The EDB DDL Extractor does not extract objects that have names like BIN$b54+4XIEYwPgUAB/AQBWwA= =$0. If you want to extract these objects, you must change the name of the objects and re-run the extraction process.


3 Migrating a Database : 3.1 Schema Extraction

Table of Contents Previous Next