The Open Source Swiss Army Knife

/sql_servers/oracle/
/sql_servers/oracle/ + sub-categories		 http://www.sirfsup.com/
web directory content
     
      

Not logged in
Chat Register Login
return to:  http:/www.sirfsup.com      /sql_servers   /oracle 
Permalink: transportable_tbs.htm
Title: add
article options : please login   |  print view
limitations
same platform and version
need have same users on destination because users go with the tablespces
    steps
  • check constraints and self-sufficency
    DBMS_TTS checks if the tablespaces are transportable.
    EXECUTE DMBS_TTS.TRANSPORT_SET_CHECK('AP_DATA,AP_INDEX',TRUE); does such a check for these two tablespaces. TRUE means check constraints.
  • alter tablespace ap_data read 0nly
  • alter tablespace ap_index read 0nly
  • Exp transport_tablespace=y tablespaces=ap_data,ap_index triggers=y constraints=y grants=y file-tts.dmp
  • cp ap_data /new/destination
  • cp ap_index /new/destination
  • import into the new database
    Imp transport_tablespace=y datafiles=(d:\oracle\ap_db\data\ap_data01.dbf,e:\oracle\ap_db\data\ap_index.dbf) file=tss_dmp tablespaces=(ap_data,ap_index) owners=(ap_dba);
  • ALTER TABLESPACE ap_data READ WRITE
  • ALTER TABLESPACE ap_index READ WRITE
(#594) poster : anonymous (owner)date: 2008-09-16

AL9NVA wazdacaulwxk, [url=http://dsebkaxbfrce.com/]dsebkaxbfrce[/url], [link=http://zsxygilbhsgr.com/]zsxygilbhsgr[/link], http://afmohnvemzlw.com/
Leave a Reply
Your Name:     anonymous
Your Email:
Website:  
Comments:

The author will be notified of your reply.
return to top
24078 [ 483 MB ] of Articles and Code Samples   
5897 pages in the directory #!/bin/sh sys=0; rec=0; for i in `ls *.pagecount`; do sys=$(cat $i); rec=$(( $rec + $sys)); done; echo $rec;
849 Users
Online Since Mar 3 2002
design help and support from mynd4rent design
Don't Worry! The Material on Sirfsup.com is Your Copyright as the Author