| Migrating databases(windows to windows) [message #548948] |
Tue, 27 March 2012 06:17  |
|
|
HI,
I have the task to migrate the total databases(Exact copy to be moved to another server).The current server is going for format.
After I did the following steps I am getting the tablespaces(databases)-4 sizes same ,but I am facing issue like some default tablespaces i.e temp,system are not matching.
temp tablespace
***************
current server - 4.0(approximately)
Migrating server - 160 MB
System tablespace
*****************
current server - 580 MB
Migrating server - 220 MB
Also I checked the tables are also matching for the 4 databases.
Please suggest me how to verify and solve the issue.
Also Provide the solution or method which is correct.
steps done for migrating(By me)
********************************
EXPORTING DATA USING DATAPUMP
*********************************
1 From command prompt
MKDIR 'c:\oraclexe\app\tmp';
2 From SQL prompt
conn system/kotak;
3 create or replace directory dmpdir as 'c:\oraclexe\app\tmp';
4 grant read,write on directory dmpdir to kotak;
5 From command prompt
expdp system/kotak@xe full=Y directory=dmpdir dumpfile=xe.dmp logfile=expdpxe.log;
IMPORTING DATA USING DATAPUMP
*****************************
in another server machine
1 From SQL prompt
conn system/kotak;
2 create or replace directory dmpdir as 'c:\oraclexe\app\tmp';
3 grant read,write on directory dmpdir to kotak;
4 From command prompt
set ORACLE_SID=xe;
5 impdp system/kotak@xe full=Y directory=dmpdir dumpfile=xe.dmp logfile=impdpxe.log;
IN OUR PROCESS we created the below tablespaces and user before IMPORTING
created 4 tablespaces
1. kotak
2. kotakdb
3. wired_data
4. ferrari
Created Users which are there in 219 server
1. KOTAK
2. KOTAKDB
3. FC_80
4. DEMOINTERNETBANK
5. DEMOINTERNETBANKDB
6. CREDITCARD
Regards
Uday Kumar.R(Expecting answer/solution)
|
|
|
|
| Re: Migrating databases(windows to windows) [message #549018 is a reply to message #548948] |
Tue, 27 March 2012 09:06  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>>but I am facing issue like some default tablespaces i.e >>temp,system are not matching.
It does not have to.
System depends on options you are using.
Temp, well, it is temporary tablespace. Trying to "match" it makes no sense.
As long as tables / their records counts , objects and their functionality are reproducible it should be good.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
