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.
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.