Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export table data

Status
Not open for further replies.
craig322

craig322

MIS
Apr 19, 2001
108
US
I have a table that contains 7 million + rows. I need to export selected rows from this table to import into an Oracle database. This will be a nightly task. What is the easiest/quickest way to do this? The unload utility seems to be slow.

Thanks in advance for any help.

Craig
 
Sort by date Sort by votes
Can't think of anything that would be faster. Make sure you have indexes on the fields that you are using in your "WHERE" clause. This can speed things up considerably.

Jane
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

tuccero
  • Locked
  • Question
onstat -g ses returns "Changing data structure forced command termination"
Replies
1
Views
285
tuccero
tuccero
evgeniosc
  • Locked
  • Question
Copy rows as they inserted on a replica table using trigger
Replies
0
Views
151
evgeniosc
evgeniosc
KaronW
  • Locked
  • Question
Do multiple "case" lines run against each line or is each run against the table ?
Replies
0
Views
140
KaronW
KaronW
marcq
  • Locked
  • Question
Table space usage vs tables
Replies
0
Views
94
marcq
marcq
aft5425
  • Locked
  • Question
Avoid duplicates on phn_nbr while joining a table to itself
Replies
1
Views
117
PHV
PHV

Part and Inventory Search

Sponsor

Back
Top