- Will the import utility prompt me to only import data into the existing tables?
- Will the .zl file overlay the existing data?
- Do I initiate the import utility from the command prompt?
imp SYSTEM/password PARFILE=params.parYou would have created your parameter file ahead of time with the appropriate parameters. The parameter file might look similar to this:
FILE=filename.zl SHOW=n IGNORE=n GRANTS=y ROWS=y FROMUSER=blake TOUSER=scott TABLES=(unit,manager)Note that these are not the only import parameters available. You should review the Oracle9i Database Utilities Guide to familiarize yourself with the parameters. The guide can be downloaded from Oracle Technology Network by clicking here.
If you choose to use the import facility interactively, you must provide much of the same information when prompted. To use import interactively, type:
impat the command prompt.
I've assumed that you want to import a schema only and not an entire database. If the export is a full database export and you want to import the entire database, then you must include the full=y parameter in your parameter file and exclude the TOUSER and FROMUSER parameters as these no longer apply once you specify that you want to import the entire database. Prior to importing a schema, be sure to first create the appropriate tablespaces and the schema owner account, as well as any roles that need to be granted during the import.
With respect to your first question, there is an import parameter called IGNORE. The default setting for this parameter is N, which means that the import utility will log or display object creation errors before continuing. So if it is trying to import a table that already exists, it will report an error and continue on to the next object. If, however, you set IGNORE=Y this means that import overlooks object creation errors when it attempts to create database objects, and continues without reporting the errors. If a table already exists and IGNORE=y, then rows are imported into existing tables without any errors or messages being given.
Finally, with respect to your second question, when you import into existing tables, if no column in the table is uniquely indexed, rows could be duplicated.
Dig Deeper on Oracle database installation, upgrades and patches
Related Q&A from Maria Anderson
Can I use /var/opt/oracle/oratab to specify listener information? Continue Reading
We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ... Continue Reading
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error: "Error in invoking target install of makefile /opt/oracle/...../*.mk." Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.