Home » RDBMS Server » Backup & Recovery » import dump from 8i(windowsNT) to 9i(windows 2003)
import dump from 8i(windowsNT) to 9i(windows 2003) [message #183553] Fri, 21 July 2006 05:24 Go to next message
Raoul
Messages: 20
Registered: April 2005
Junior Member
Hello

Does anybody know if there would be any problem(s) importing an Oracle 8i (on windows NT) dump into an Oracle 9i (on windows 2003)?

Many thanks,
Raoul

Report message to a moderator

Re: import dump from 8i(windowsNT) to 9i(windows 2003) [message #183566 is a reply to message #183553] Fri, 21 July 2006 06:35 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
No (as long as you do it right).
Use the lower version of exp to export
Use the lower version of imp to import.
Precreate the database/tablespaces/datafiles/users with default tablespaces etc.
In 9i use UNDO tablespace with UNDO_RETENTION configured.
Search the forum/documentation/google for more details.

Report message to a moderator

Re: import dump from 8i(windowsNT) to 9i(windows 2003) [message #183728 is a reply to message #183566] Sat, 22 July 2006 14:10 Go to previous message
Raoul
Messages: 20
Registered: April 2005
Junior Member
Many thanks.

Report message to a moderator

Previous Topic: prev Cold bakup after recent shu is meaningful or not
Next Topic: Export Problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 07:47:13 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.