Create and adjust Tablespaces - Intergraph Smart Materials - Version 10.2 - Installation & Upgrade - Hexagon

To create the Smart Materials specific tablespaces (MARIAN, M_INDEX, M_TEMP) and to change the size of SYSTEM and USERS tablespaces up to 250MB, use this sample script that is provided with the software:

%SMAT_DB_InstallFolder%\samples\SMat\create_tablespace_sample.sql

Proceed as follows:

1. In the sample script, replace the place holder

   ‘{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\<PDB-DIRECTORY>\DATAFILE\’

   with your datapath, for example

   'C:\oracle\19c_s ta\base\oradata\CDB\SMAT\DATAFILE'

   or

   ‘C:\oracle\19c_sta\base\oradata\CDB\550B5B6124BC4ACD84B15C73EE297078\DATAFILE’

2. Open a Command Prompt as administrator.

3. Set oracle_home=C:\oracle\19c_sta\db

4. Navigate to the directory where the modified sample script is stored.

5. sqlplus /nolog

6. To check if the PDB instance is running, execute:

   • conn sys/<sys_password>@<SID of CDB> as sysdba

   • select con_id, name, open_mode from v$pdbs;

     The status of PDB instance should be 'Read Write'.

     

   • If status is not 'Read Write', execute:

     alter pluggable database <your pdb instance name> open;

   • Check again:

     select con_id, name, open_mode from v$pdbs;

7. conn sys/<sys_password>@<CDB instance> as sysdba

   for example:

   conn sys/manager@CDB as sysdba

8. alter session set container = <PDB instance>;

   for example:

   alter session set container = smat;

   Ensure that you are connected to PDB (SMat) and not to CDB.

9. @create_tablespace_sample.sql

10. Check the logfile create-smat-tablespace.log.