Use these guidelines to create a new Oracle Database on the target system.

The new target database consists initially of just SYSTEM, SYSAUX, UNDO, temporary tablespaces, and user tablespaces. To create the target database, you can use Database Configuration Assistant (DBCA).

When creating the target database, consider the following:

• Ensure either that the tablespaces for the SYSTEM, SYSAUX, UNDO, and temporary tablespaces have adequate free space, or that AUTOEXTEND is set to ON for those tablespaces.

• Ensure that the sizes of log files and number of members for each log file group in the new target database are the same as, or larger than, the source database.

• Ensure that the source and target database use the same character set and same national character set. Check the source database character sets by issuing the following query:

  SQL> select * from database_properties where property_name like '%CHARACTERSET';

• Ensure that the database options and components used in the source database are installed on the target database.

  • To view currently installed database options, query the V$OPTION view

  • To view currently installed database components, query DBA_REGISTRY.