| export of 100gb database [message #69480] |
Thu, 17 January 2002 11:22  |
srikanth
Messages: 40
Registered: July 2001
|
Member |
|
|
Hi all,
Pls. suggest some ways to go about taking export dumps of 100gb of database in a DLT directly. The data available will be approximately 90 GB of data. pls. metion the syntax also.
Thanx in advance.
|
|
|
|
| Re: export of 100gb database [message #69485 is a reply to message #69480] |
Fri, 18 January 2002 08:04  |
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
|
Senior Member |
|
|
Use PIPE and put the output into a compressed file.
90 GB data DOES not mean that the export output file will be 90 GB. My guess will be around 3-4 GB compressed. But I may wrong too.
Good luck.
|
|
|
|
| Re: export of 100gb database [message #69542 is a reply to message #69480] |
Tue, 29 January 2002 14:33 |
Sandra
Messages: 6
Registered: November 2001
|
Junior Member |
|
|
Oracle 8i lets you create a multiple-file export. There's a new export parameter called FILESIZE.
Full description in the Oracle Utilities manual, Export chapter.
hth,
Sandra
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
