No question at this time
DBA Top 10
1 M. Cadot 5400
2 P. Wisse 1300
3 P. Tsongayinwe 900
4 B. Vroman 500
4 J. Schnackenberg 500
6 M. Pagac 400
7 A. Deledda 200
7 D. Walgude 200
7 B. M 200
10 J. Alcroft 100
10 G. Trivedi 100
10 A. Hudspith 100
10 V. Sharma 100
10 L. Ywema 100
About
DBA-Village
Advertise here
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48741
Total active users1338
Act. users last 24h6
Act. users last hour0
Registered user hits last week145
Registered user hits last month435
Go up

Data Migration
Next thread: Dynamic Sql
Prev thread: How to clean up older records in AUD$ table

Message Score Author Date
Dear DBA I have to migrate database in server1 ...... prashansh kumar Jan 17, 2014, 11:49
Hello Prashansh, simply use expdp from source d...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Bruno Vroman Jan 17, 2014, 12:07
Dear Bruno It means that it will support larger...... prashansh kumar Jan 17, 2014, 12:10
Im not sure Im mega keen on DataPump when changing...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Adam Hudspith Jan 17, 2014, 12:35
Adam, An RMAN dump...I thought those were platf...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Tim Boles Jan 17, 2014, 19:00

Follow up by mail Click here

Subject: Data Migration
Author: prashansh kumar, India
Date: Jan 17, 2014, 11:49, 3419 days ago
Os info: linux
Oracle info: Oracle11g
Message: Dear DBA

I have to migrate database in server1 in windows platform to Linux platform in server2.

Server1 :- database is created in 8k block size. But in server2 is configured for 16K block size.

Que1: Can we migrate data from server1 to server2?

Note:-Please should not consider any performance related issue.

regards
Prashansh
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: Data Migration
Author: Bruno Vroman, Belgium
Date: Jan 17, 2014, 12:07, 3419 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Hello Prashansh,

simply use expdp from source database + impdp in a "fresh new empty" database.

Best regards,

Bruno Vroman.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: Data Migration
Author: prashansh kumar, India
Date: Jan 17, 2014, 12:10, 3419 days ago
Message: Dear Bruno

It means that it will support larger block by default and you can do simple export and import operation.

Thanks & Regards
Prashansh
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: Data Migration
Author: Adam Hudspith, United Kingdom
Date: Jan 17, 2014, 12:35, 3419 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Im not sure Im mega keen on DataPump when changing endianness.

Old fashioned exp/imp would likely work tho... since it's a flat file.

Or the fastest way... use RMAN to dump a duplicate of the database to the new host. I did that 2 days ago when changing from 32bit to 64bit ;)
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: Data Migration
Author: Tim Boles, United States
Date: Jan 17, 2014, 19:00, 3419 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Adam,

An RMAN dump...I thought those were platform specific. You used an RMAN dump to go from Windows to Linux. Now that is a really cool way of doing it.

Regards
Tim
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here