| import question [message #51739] |
Tue, 11 June 2002 11:03  |
Jhon Bruinsma
Messages: 13
Registered: May 2002
|
Junior Member |
|
|
Hi,
I hope someone can help me out here. I need to restore a DB (8.1.5) from NT to solaris. So I want to use the imp/exp utilities (or is there a better way?). The source DB has many packages, triggers, pk-fk relations between many tables etc.. Its quite big DB (40G). The solaris machine (2.6) has a filesize limit of 2G. Oh boy, the full exp dump file is MUCH bigger than 2G. That's my problem: I can't put the file on solaris. Can it be solved, or does anyone have an idea?
I already tried a table per table export, and a table per table import. Then I get the data allright, but the
I miss the packages, and the triggers, PK, FK etc.. is a horrible mess.
I VERY MUCH appreciate any tip or clue or pointer.
Thanks!
|
|
|
|
| Re: import question [message #51740 is a reply to message #51739] |
Tue, 11 June 2002 11:09  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
The amount of stuff you can extract from INDEXFILE varies from version to version (it keeps getting more). Try it to see what you get:
exp scott/tiger rows=n file=tmp.dmp
imp scott/tiger file=tmp.dmp indexfile=tmp.sql
Also - in unix try:
strings tmp.dmp > tmp_ddl_etc.sql
I'd personally use TOAD to extract all the DDL , Source, Grants etc etc.
|
|
|
|
| Re: import question [message #51742 is a reply to message #51739] |
Tue, 11 June 2002 12:04 |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
Use FILE and FILESIZE:
exp system/manager file=(file1,file2...) FILESIZE=1G
You may have to specify the actual number. Then copy the files over and imp:
imp system/manager file=(file1,file2...) FILESIZE=1G ...
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
