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

Intergraph Smart Materials Installation (10.1)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Installation & Upgrade
Smart Materials/Smart Reference Data Version
10.1

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:

In case of a fresh install, for smooth functioning, it is necessary to change the size of the tablespace MARIAN and M_INDEX as following.

  • Create tablespace MARIAN datafile size 4096M auto extend on next 10240K.

  • Create tablespace M_INDEX datafile size 4096M auto extend on next 10240K.

%SMAT_DB_InstallFolder%\samples\SMat\create_tablespace_sample.sql

Proceed as follows:

  1. Open a Command Prompt as administrator.

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

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

  4. sqlplus /nolog

  5. 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'.

      CreateDB09_pdb-status

    • 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;

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

    for example:

    conn sys/manager@CDB as sysdba

  7. 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.

  8. @create_tablespace_sample.sql

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