-
Login with the local administrator account.
-
On the source database (Oracle 12c/Smart Materials 8.0.0 to 8.3.0, or Oracle 18c/Materials 8.4.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 18c, Smart Materials 10.0.0), 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/Materials 8.4.0), create a dump file as described under Back Up the 8.x.x.x Database.
-
Open a SQL Plus session against the target (Oracle 18c, Smart Materials 8.0.0) 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 8 dump file must be placed in this folder.
-
Now set the rights with this command:
Grant read,write on directory dpump to system;
-
Open a Command Prompt window as an administrator.
-
Set the oracle home of your database, for example:
set ORACLE_HOME=C:\oracle\18c_Sta\db
-
Perform the import with the Oracle impdp tool (replace <system_pw> with the password of system user, and SID with the name (sid) of your database):
impdp system/<system_pw>@SID full=y directory=dpump dumpfile=SID.DMP logfile=impSID.log
-
After the import successfully completes, check the logfiles for errors.
-
Now, run the following post import script:
%SMAT_DB_InstallFolder%\samples\post_import\import_<your SMat Version>\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.