Skip to main content

Search

Welcome to Tibero GTS!

Applying Profiles When Migrating Data from Tibero to Tibero

Document Type | Technical Information

Category | Migration

Applicable Product Version | 7FS02PS

Document Number | TMITI005

 

Overview

This guide explains the method to apply profiles when migrating data from Tibero to Tibero.
Caution
  • Profiles cannot be applied during export/import operations. Therefore, profiles must be applied separately.
  • If there are user-defined profiles other than the default profile, verify and create them separately.

 

 
 

Method

1. Check profiles

SQL> select * from dba_profiles;

 

2. Create profiles

SQL> select DISTINCT 'create profile "' || PROFILE || '";' from dba_profiles where profile not in ('DEFAULT');

 

3. Extract profile settings

SQL> select 'alter profile "' || PROFILE || '" limit ' || RESOURCE_NAME || ' ' || LIMIT || ';' 
from dba_profiles where profile not in ('DEFAULT');
--If no options are specified for the profile, it follows the default profile values

SQL> CREATE PROFILE <profile_name>;
SQL> ALTER USER <username> PROFILE <profile_name>;

 

4. Check profiles applied to users

SQL> select * from dba_users;

 

 

 

 

 

 

Related to