Documentation Center

Creating a Contenta S1000D database

After installing Contenta S1000D, import a Contenta S1000D database that contains all the appropriate object types and structure, but no content.

Before you begin

Ensure that Contenta is installed and functioning correctly.

Procedure

  1. Copy the appropriate s1000d.dmp from the following location to a temporary directory.
    Database VendorPath
    OracleContenta_home/S1000D_samples/databases/Contenta511_Oracle19c_database or

    Contenta_home/S1000D_samples/databases/Contenta511_Oracle18c_database

    MS SQL ServerContenta_home/S1000D_samples/databases/Contenta511_MSSQLServer_database

    For Oracle, the temporary directory must be on a system that has pcmadmin installed. For MS SQL Server, the temporary directory must be on the MS SQL Server system.

  2. At a command prompt, enter the appropriate command.
    Database VendorCommand
    Oracledbimport.pl -dbase dbase@sid -i "tempdir"
    MS SQL Serverdbimport.pl -dbase dbase -i "tempdir"
    Database VendorCommand-line optionDescription
    Oracle-dbaseName and Oracle SID of the new database.
    -iDirectory path and filename where the s1000d.dmp file is located.

    Enclose in quotation marks.

    MS SQL Server-dbaseName of the new database.
    -iDirectory path and filename where the s1000d.dmp file is located.

    Enclose in quotation marks.

    For more information on command-line options for the Database Import Command, refer to Database Maintenance Commands in the Contenta Administration documentation.

What to do next

Now that you have a Contenta S1000D database, modify the default AppData values as needed in the database. See Modifying AppData settings after installing or upgrading Contenta S1000D.