Home » Infrastructure » Windows » Migrating 10g r1 server from os windows 2000- 2003 (10g r1 windows 2000)
Migrating 10g r1 server from os windows 2000- 2003 [message #354187] Thu, 16 October 2008 21:58 Go to next message
sureshm.ora
Messages: 17
Registered: August 2008
Location: BANGLORE
Junior Member
Hello hai..

just i need your help regards to migrating oracle 10g r1 server from windows 2000 to 2003 .for this i want to do full database exp ( source ) and importing on target . for this operation which user(system or some other ) is the best to do full database imp and exp.. please help me ... how to proceed....


regards
suresh

[Updated on: Thu, 16 October 2008 21:59]

Report message to a moderator

Re: Migrating 10g r1 server from os windows 2000- 2003 [message #354197 is a reply to message #354187] Thu, 16 October 2008 23:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Any user with DBA role, it does not matter unless you use FGAC/VPD.

Regards
Michel
Re: Migrating 10g r1 server from os windows 2000- 2003 [message #354201 is a reply to message #354197] Thu, 16 October 2008 23:57 Go to previous messageGo to next message
sureshm.ora
Messages: 17
Registered: August 2008
Location: BANGLORE
Junior Member
thanks for your replay

Just i need small info when we are trying to do full database importng what are the considerations we have to follow, before improting we need to create users and assign tablespaces for them ? . what abt roles and grants .. please help me..



thanks

suresh
Re: Migrating 10g r1 server from os windows 2000- 2003 [message #354209 is a reply to message #354201] Fri, 17 October 2008 00:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Import full does all these things but you must have the same directories otherwise you have to precreate the tablespaces.

Regards
Michel
Re: Migrating 10g r1 server from os windows 2000- 2003 [message #354280 is a reply to message #354209] Fri, 17 October 2008 05:54 Go to previous messageGo to next message
sureshm.ora
Messages: 17
Registered: August 2008
Location: BANGLORE
Junior Member
Thanks for your replay

just i need small info regards when importing(with system user ) full database level into some other database is it going to effect the existed system schema and all other schemas objects any data crash will happen . if it(imp full database) is into empty database what will happen . please help me....


thanks
suresh

[Updated on: Fri, 17 October 2008 05:58]

Report message to a moderator

icon6.gif  Re: Migrating 10g r1 server from os windows 2000- 2003 [message #354538 is a reply to message #354187] Mon, 20 October 2008 03:53 Go to previous message
james_briar
Messages: 39
Registered: April 2005
Location: Morden (South London)
Member
Hello suresh,
I've done the following before to copy a database from one Windows server to another that's on a different version :-

Do a full database export on the source server (from DOS i've done "exp parfile=exp_file" :-

The exp_file file contains :-
userid=’sys/xxxx@test as sysdba’
full=y
compress=n
direct=y
file=’exp_test.dmp’
log=’exp_test.log’

On the destination server i create a new empty database the same as the source one and create the required views etc (catproc, catalog and whatever etc). I then FTP the export dump (in binary) to this new server and from DOS i do a full database import "imp parfile=imp_file" :-

imp imp_file contains :-
userid=’sys/xxxx@test as sysdba’
full=y
ignore=y
file=’exp_test.dmp’
log=’imp_test.log’
buffer=10240000

The import creates all the database users/schema's etc.

Hope this helps.

There's a new feature on Oracle10g called Datapump but i've not used this yet (replacement for exp/imp etc).
Previous Topic: BULK LOAD DATA FROM XML INTO ORACLE .NET
Next Topic: about file's modified date
Goto Forum:
  


Current Time: Thu Mar 28 09:14:02 CDT 2024