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;