The limition of AUL/MyDUL dmp format

    The basic target of AUL/MyDUL is to recover data, so the dmp file contains the data you required. When you use exp utility to export a table from Oracle database, the dmp file contains the full syntax of recreate the table, indexes, all the constraints, triggers of the target table. But in the dmp file of AUL/MyDUL, it just contains a basic create table SQL, it will not contain the following:

1, The storage definition of the table.
2, The partition & sub-partition definition.
3, The indexes associated with the table.
4, The constraints associated with the table except the "NOT NULL".
5, The default values defined on the columns.
6, The triggers defined on the table.
7, The privileges granted to other schema.

    And the export schema of the dmp file is always "mydul", each table a dmp file, the dmp format version is Oracle 8.1.7, you must use exp version 8.1.7 or higher to import it to new database. And no multiple dmp file support as exp do. Some customers have asked me this question. Maybe I will enhance it in later releases (no recent plan for these feature).

Post a comment

SCode:
Mail(*, but will not be displayed):
Home: