Import the Smart Materials Dump - Intergraph Smart Materials - Version 10.1 - Installation & Upgrade - Hexagon

Login with the local administrator account.

On the source database (Oracle 12c/Smart Materials 8.0.0 to 8.3.0, or Oracle 18c/Smart Materials 8.4.0 to 10.0), grant the EXPORT FULL DATABASE role to the SYSTEM user, with this command:

grant exp_full_database to system;

On the target database (Oracle 19c), grant the IMPORT FULL DATABASE role to the SYSTEM user with this command:

grant imp_full_database to system;

On the source database (Oracle 12c/Smart Materials 8.0.0 to 8.3.0, or Oracle 18c/Smart Materials 8.4.0 to 10.0), create a dump file as described under Backup the 8.x/10.x Database.

Open a SQL Plus session against the target (Oracle 19c) database into which the dump should be imported.

Connect with sys as sysdba.

Create a directory into the database with this command:

Example:

create directory dpump as ‘D:\tmp‘;

This directory must exist on the file system, and the Smart Materials dump file must be placed in this folder.

If you use Smart Materials Web, ensure that the APEX related tablespace of your source database is available in your new database, before importing the database dump. To do this, perform the following:

1. On your source database, execute:

   SELECT * FROM dba_tablespaces where tablespace_name like 'APEX%';

2. On your new database, create the tablespace with this command (replace APEX_xxxx with the tablespace name of the source database selected with above command, and <your Datapath> with an appropriate path):

   Create Smallfile Tablespace "APEX_xxxx" datafile size 4096M autoextend on next 100m;

   For example: Create smallfile tablespace "APEX_BIR SPMAT" datafile size 4096M autoextend on next 100m;

   Now set the rights with this command:

   Grant read,write on directory dump to system;

Open a Command Prompt window as an administrator.

Set the oracle home of your database, for example:

set ORACLE_HOME=C:\oracle\19c_Sta\db

Set nls_lang value:

set NLS_LANG=AMERICAN_AMERICA.AL32UTF8

Copy the parfile from %SMAT_DB_InstallFolder%\samples\SMat to the folder where you execute the import.

Perform the import with the Oracle impdp tool (replace <system_pw> with the password of system user, and SID with the PDB instance name of your database):

impdp system/<system_pw>@SID full=y directory=dpump dumpfile=SID.DMP logfile=impSID.log parfile=exclude.par

After the import successfully completes, check the logfiles for errors.

Now, run the following post import script:

%SMAT_DB_InstallFolder%\samples\post_import\import_general\post_import.sql

The post_import script recompiles and analyzes your database after the import.

Ensure you use the latest version of the post_import.sql script, which is provided with the latest Service Pack. The script is available in above mentioned sub-directory after database setup installation of the Service Pack.