Table of Contents Previous Next


3 Migrating a Database : 3.2 Schema Assessment

To assess an Oracle database schema for compatibility with Advanced Server, you must:
Please Note: You must connect with a database role that has SELECT_CATALOG_ROLE or SELECT ANY DICTIONARY privileges.
2.
Run the DDL Extractor with the command: SQL>@edb_ddl_extractor.sql.
The EDB DDL Extractor uses the SQL*Plus ACCEPT command to get user input of multiple schema names using ',' delimiter. Maximum 240 bytes can be accepted. So, the maximum length of schema name can be of 30 characters and you can input 7 to 8 schema names.
Enter the path to store DDL file: /home/oracle/extracted_ddls/
6.
Click CREATE PROJECT to create a new project.
8.
Upload the .SQL file generated by the EDB DDL Extractor for Oracle Database. Please Note: You should not modify the .SQL file.
9.
Click RUN ASSESSMENT.
14.
On the Knowledge Base tab, you can enter the object name which is not compatible with Advanced Server and click Search.
Please Note: In case the object is not available in the Knowledge Base, please contact the support team for assistance.


3 Migrating a Database : 3.2 Schema Assessment

Table of Contents Previous Next