| Migrating 10g r1 server from os windows 2000- 2003 [message #354187] |
Thu, 16 October 2008 21:58  |
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 #354201 is a reply to message #354197] |
Thu, 16 October 2008 23:57  |
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 #354280 is a reply to message #354209] |
Fri, 17 October 2008 05:54 |
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 |
|
|
|
 Re: Migrating 10g r1 server from os windows 2000- 2003 [message #354538 is a reply to message #354187] |
Mon, 20 October 2008 03:53 |
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).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
