Skip to main content

Search

Welcome to Tibero GTS!

Resolution for Missing Default Tablespace Clause Issue during tbimport Execution

Document Type | ITroubleshooting

Category | Migration

Applicable Product Versions | 6FS07, 6FS07PS, 7FS02, 7FS02PS

Document Number | TMITS012

 

Issue

When performing tbimport with default_password=y, the default tablespace clause is missing in the user creation statement.
 

How to Verify Missing Default Tablespace Clause

1. Create User
SQL> create user u1 identified by u1 default tablespace system;

2. Execute tbexport
tbexport full=y sid=$TB_SID port=4242 username=sys password=tibero

3. Drop User
SQL> drop user u1 cascade;

4. Execute tbimport full=y default_password=y command
tbimport full=y sid=$TB_SID port=4242 username=sys password=tibero script=y default_password=y

5. Upon checking the import log, confirm the default tablespace clause is missing in the user creation statement
importing schema "U1"
CREATE USER "U1" IDENTIFIED BY tibero
/
...
Note
Explanation of default tablespace
This option causes all users' passwords to be set to tibero during tbimport.
This option is provided to prevent user creation failure when performing tbimport due to differences in password encryption methods during upgrade from Tibero5, 6 to Tibero7.

 

Cause

The issue occurs because the default tablespace clause is omitted due to an internal logic error during tbimport execution.
 
 

Solutions

1. Apply the patch to resolve the issue. (Applied patch: 299388)
Caution
Apply the patch through technical support provided by Tmax Tibero.
2. Alternatively, you can attempt to resolve the issue by setting a workaround.
  • You can bypass the issue by creating tablespaces and users in Tibero7 before performing tbimport.
 

 

 

Related to