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

Thread: 7.3.4 - best way to 'mass extract' data?

Threaded View

  1. 06-15-2004, 12:40 PM #1
    Axr2
    Axr2 is offline Senior Advisor
    Join Date
    Oct 2002
    Posts
    807

    7.3.4 - best way to 'mass extract' data?

    What's the best way to mass extract data in 7.3.4? Source table : 100 mill records. Some date condition applied to it results in 5 million records. I need to insert these 5 mill in a remote database.

    Note : 7.3.4 - no concept of nologging, partitioning, export/Query etc.

    A pl/sql loop will take AGES. Does not seem smart.

    Any suggestions?

    PS : Oh, and I am working with limited space on both machines.
    Last edited by Axr2; 06-15-2004 at 12:47 PM.
    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