-
AT 300 GB, I think most of it would be row data.
I suggest, instead of exporting the whole database at one go, you export the structure first (with rows = N). After importing the structure, you can export/import rows or even load data using SQL*loader.
-
Hi,
it's not he OS
NT 5.0 could store Exabytes?
http://www.raidtoolbox.com/support.html
Orca
I think the filesize is limited by 64Bit -Address-pointer.
So 300G should never be a problem.
Hey Unix!! what's with your 2G-Limitation?
Is ist always the same tables it stops?
Orca
-
nt supports large files if it´s ntfs huh
-
Originally posted by pando
nt supports large files if it´s ntfs huh
Yes, as you can read on the html-link.
But i would say VERY LARGE Files!
Orca
-
After export DB with ROWS=N, i must load data
into a certain order because a referential integrity!
Unix don't support importfile more than 2G??
-
It seems u are using windows 2000 . let me know if your hard disks are properly merged . if the export terminates in the middle just check if the .dmp file size if it has reached hard disk capacity ?
alternative solution is try using tablespace / schema option in your export.
siva prakash
DBA
-
Originally posted by bensmail
After export DB with ROWS=N, i must load data
into a certain order because a referential integrity!
Unix don't support importfile more than 2G??
You can import the data into the Unix-Db from the win2k-Server.
imp user/pwd@unix_db_serviceName ...
Orca
Importing with constraints is slow!
Before inserting data you should dsiable all constraints.
Orca
-
Thank's ALL it works:
With ROWS=N and with disabling constraints before IMPORT.
-
Originally posted by bensmail
The goal for this export is to migrate a instance (300G)
from Win2000 to Unix.
Is there another method to migrate without exp/imp?
Export and Import structure first, then the small tables.
For the large tables use direct-load insert. You need both instances running and db link created.
Approved, definitely faster than exp/imp.
Ales The whole difference between a little boy and an adult man is the price of toys
-
Originally posted by ales
Originally posted by bensmail
The goal for this export is to migrate a instance (300G)
from Win2000 to Unix.
Is there another method to migrate without exp/imp?
Export and Import structure first, then the small tables.
For the large tables use direct-load insert. You need both instances running and db link created.
Approved, definitely faster than exp/imp.
Hi,
how then you will control COMMIT; So you need to define for every Table a PL/SQL-Block.
Orca
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
|