Import/export

[Paul H]

I have two databases "test" and "live" both are structured the same. I want to resize the "test" DB and then import a full export of the "live" into the "test". Are any special parameters required?? nb both the databases have different names and reside on the same NT server.

[jgmagnus]

as long as you EXPORT=FULL from the 'live' DB and you have created the same tablespaces/datafiles on the 'test' DB then you should be fine to import as sys.

- Magnus

ps: i am assuming you know to do tables=Y and rows=Y etc.


[Edited by jgmagnus on 09-10-2001 at 11:27 AM]

[kris109]

You may want to check on ignore=Y parameter.

For tables, IGNORE=Y causes rows to be imported into existing tables. If a table already exists, IGNORE=N causes an error to be reported, and the table is skipped with no rows inserted. Also, objects dependent on tables, such as indexes, grants, and constraints, will not be created if a table already exists and IGNORE=N.