Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Exporting Script output of 7 Million records

tbhluehornFeb 20 2017 — edited Mar 13 2017

Using SQL developer 4.0.0

I am trying to export a large script output.

There are 9 million records.

I tried to export to xlsx but I think that excel will not support this many for sure.

I have exported to TSV  text file that is about 1.5 gb in size.  Please advise on what I can use to view the data as records . I have tried Note++ and Notepad.

Please let me know another way to work with large outputs if you have any.

This post has been answered by unknown-7404 on Feb 20 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 10 2017
Added on Feb 20 2017
8 comments
649 views