source:
1. select owner|| '.' ||, segment_type,tablespace_name from dba_segments where tablespace_name in ('tablespace_name')
if you want to add any user then
create user
grant connect, resource to
2. alter tablespace
3. execute dbms_tts.transport_set_check('
4. select * from transport_set_violations;
-- This should return 'NO ROWS SELECTED'
Export:
exp "'/as sysdba'" file = exp_tts.dmp log=exp_tts.log transport_tablespace=y tablespaces=
5. copy the .dmp file to target $ORACLE_HOME
6. Copy the datafile to target destination
Destination:
if you want to create user
then
create user
grant connect, resource to
7. Import
imp "'/as sysdba'" file=exp_tts.dmp log=imp_tts.log fromuser =
source and destination
No comments:
Post a Comment