Home » RDBMS Server » Server Utilities » Database importing in different version of oracle
Database importing in different version of oracle [message #23759] Fri, 03 January 2003 02:59 Go to next message
balwan
Messages: 17
Registered: January 2003
Junior Member
I am getting the strange problem while importing the database from oracle (8.1.7) to oracle (8.0.6) or vice versa.
The problem is my sequences getting starting from initial value again.
Do any body had this kind of problem before. If yes what is the cure for this.

Thanks in advance.
Re: Database importing in different version of oracle [message #23765 is a reply to message #23759] Fri, 03 January 2003 06:14 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
it is expected.
first, run the export/import using the lower version.
create the sequences with NOCACHE option and
use consistent=Y during export.
else
create script which collects the values of LAST_NUMBER 
of view DBA_SEQUENCES on source system( where Export 
is run) update sequence on target system ( where Import is run) to be equal to
LAST_NUMBER so that application sees no gap.

Previous Topic: Re: FREE OCP PAPERS
Next Topic: svrmgrl problem after an ORA-01034
Goto Forum:
  


Current Time: Tue May 14 12:51:56 CDT 2024