Use the Database Import command to create a Contenta database from a previously exported Contenta database. The exported database files is created with the database export command.
Oracle database only
Consider the following if you use an Oracle database.
Note: The optional -datapump switch uses Oracle’s Data Pump utilities, which must be configured before this switch may be used. See Configuring Oracle Data Pump for use with Contenta.
Note: When
dbimport.pl is used with the
-datapump switch, the database import behavior changes as follows:
- Database .dmp files being imported must be located on the Oracle server, not the client.
- Oracle log files are created (by dbimport.pl) on the Oracle server, not the client.
- These server-side files require an existing Oracle Directory Object, which may be specified on the command line.
- Since Oracle’s Data Pump import tool requires the source database name, the dbexport.pl output dump file name must contain the name of the database that was exported. You may supply this name to dbimport.pl, but it is usually easier to have it automatically appended by dbexport.pl, so that dbimport.pl will extract it from the input dump file name and you will not have to supply it on the command line.
Note: Running dbimport.pl with the -datapump switch is incompatible with database dump files that were created by running dbexport.pl without the -datapump switch (because Oracle’s impdp is incompatible with Oracle’s exp). If you need to import a pre- DataPump dump file, you will need to reimport it using dbimport.pl without the -datapump switch. From there you can export it using dbexport.pl with -datapump.
Important: The Oracle database administrator must set deferred_segment_creation=false before the database is exported using dbexport.pl.
MSSQL database only
Consider the following if you use an MSSQL database.
- The .dmp file must be located on the MSSQL database server. The value for the importdir argument is the full path from the database server location where the .dmp file is located.
- You cannot import a database from another server (ODBC_DSN must be resident). If you exported from a different server, move the .dmp file to the MSSQL server for this environment.