DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Transportable tablespaces

  1. 06-01-2006, 02:39 PM #1
    smruti123
    smruti123 is offline Junior Member
    Join Date
    Apr 2006
    Posts
    24

    Transportable tablespaces

    Hi
    I need to move data from Oracle 8i server1 to Oracle 9i server2.
    My plan is to use Transportable tablespaces because I need to move data only from some tablespaces, but I found that tablespaces are not self_contained . Is there any way still can I use this method?
    Thanks in advance.
    Reply With Quote Reply With Quote
  2. 06-01-2006, 02:42 PM #2
    LKBrwn_DBA's Avatar
    LKBrwn_DBA
    LKBrwn_DBA is offline Senior Advisor
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Thumbs down


    NO.

    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
    Reply With Quote Reply With Quote
  3. 06-01-2006, 02:47 PM #3
    smruti123
    smruti123 is offline Junior Member
    Join Date
    Apr 2006
    Posts
    24
    Can I disable constraints and use this method
    Reply With Quote Reply With Quote
  4. 06-01-2006, 03:57 PM #4
    dbasan's Avatar
    dbasan
    dbasan is offline Advisor
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    ......., but check for violations in TRANSPORT_SET_CHECK before doing or make them self contained.
    you may also choose not to transport constraints.
    "What is past is PROLOGUE"
    Reply With Quote Reply With Quote
  5. 06-02-2006, 09:42 AM #5
    smruti123
    smruti123 is offline Junior Member
    Join Date
    Apr 2006
    Posts
    24
    I checked using TRANSPORT_SET_CHECK and found almost 128 rows for violations.I need to move data from almost 56 tablespaces.If I use constraints=N , then still do I need to disable constraint.

    Thanks in advance
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width