| imp problem [message #51276] |
Sat, 11 May 2002 12:15  |
Jhon Bruinsma
Messages: 13
Registered: May 2002
|
Junior Member |
|
|
Hi,
Maybe someone can help me with the following question.
I have a production db on sun solaris 2.6. I have a recently got access to a test computer (a PC actually) with Win2K. The machines are in the hands of "not easily to contact" system admins. The sun machine has regrettably a filesize limit of 2G. My production db (1 schema with all objects) is about 40G: so I cannot do a full db export to 1 single file. You probably see my problem, I want to transfer the production db to the test environment, that is all tables, all packages etc.... just all objects ofcourse.
Now, normally, one does a full exp on the source machine, and then one does a full imp on the destination machine. But how can I do it in my situation? Please, any tip or hint will be highly appreciated !!!
Thanks !!!!!
|
|
|
|
| Re: imp problem [message #51281 is a reply to message #51276] |
Sun, 12 May 2002 18:39  |
Anil
Messages: 80
Registered: September 2001
|
Member |
|
|
Hello Mr. Jhon,
If in such case, you can opt full backup utility. Do the full backup and restore it to the test machine. That could solve your problem.
Thanx,
Anil.
|
|
|
|
| Re: imp problem [message #51290 is a reply to message #51276] |
Mon, 13 May 2002 06:11 |
dave777
Messages: 2
Registered: May 2002
|
Junior Member |
|
|
Hi,
Notes:30528.1 and 62427.1 from Oracle Metalink explain
every step how to solve your problem.
Regards,
dave777.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
