| Urgent! Import - basic question [message #54599] |
Fri, 22 November 2002 14:42  |
Tony
Messages: 190
Registered: June 2001
|
Senior Member |
|
|
Hi,
We are planning to do a import of a database dump from Oracle 7.3.4 to 8.0.6. Platform is sun solaris 2.5.1. Is there any issues that we need to be aware of?
Thanks
|
|
|
|
| Re: Urgent! Import - basic question [message #54613 is a reply to message #54599] |
Fri, 22 November 2002 22:28  |
sharan alva
Messages: 57
Registered: November 1999
|
Member |
|
|
Oracle export/import is forward compatible and platform independent. To answer your question there should be no problem in importing the 7.3.4 database into 8.0.6. However note if the 8.0.6 is on anohter machine make sure you ftp the dump file in binary mode.
- Sharan
ps: 8.0.6 is desupported why don't you go to 8.1.7 and higher instead?
|
|
|
|
| Re: Urgent! Import - basic question [message #54623 is a reply to message #54599] |
Sat, 23 November 2002 14:09 |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
There are few:
1. Make sure you create the export dump file with the 7.3.4 exp binary, not with the 8.0.6 through db link.
2. Transfer the dump file in binary mode if using FTP protocol (ftp>bin should do it).
3. Import with 8.0.6 imp binary.
4. Estimate the size of your dump file with this method:
$ mknod /var/tmp/exp.pipe p
$ dd if=/var/tmp/exp.pipe of=/dev/null bs=1024 &
$ exp userid=user/passwd log=/tmp/exp.log file=/tmp/exp.pipe full=y
You will get the dump file size in blocks. If the blocks*os_block_size > 2Gb, then you have use pipes to compress or split the dump file. Examples are provided Here and Here
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
If you have
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
