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

Thread: export database by tablespace in oracle 8

  1. 07-05-2006, 03:13 AM #1
    rona_a
    rona_a is offline Junior Member
    Join Date
    Jul 2006
    Posts
    9

    export database by tablespace in oracle 8

    Hi All,

    My problem is our old database is still using
    oracle 8 (not 8i) ,the problem is they create application tables
    inside SYS schema but on different tablespace, i need to separate them out. But cannot find a way to export using tablespace option. I knw 9i already have this option but i'm trapped with Oracle 8. =(

    Pls help!


    rona
    Reply With Quote Reply With Quote
  2. 07-05-2006, 04:58 AM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    no 9i has nothing different than 8i - you need to move them manually
    Reply With Quote Reply With Quote
  3. 07-10-2006, 11:57 PM #3
    rona_a
    rona_a is offline Junior Member
    Join Date
    Jul 2006
    Posts
    9
    thanks anyway..looks like i'm rly hopeless withe my problem and got no other choice but to move 'em manually... =(
    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