| database migration [message #147602] |
Fri, 18 November 2005 08:08  |
vgs2005
Messages: 123
Registered: April 2005
|
Senior Member |
|
|
hi,
i am to migrate our db from solaris to linux. it would be the same instances, same users, same data, same schema, same evrything. can you please provide me a guideline or any useful link.. i'm not a dba and the dba is not available - but this is urgent. so it would be nice if i can get simple instructions. anyway, it's the development db, not prod, so am doing it...
thanks in advance..
|
|
|
|
|
|
| Re: database migration [message #147633 is a reply to message #147602] |
Fri, 18 November 2005 11:30  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
Although why
a) this would be done at all
b) this would be done by a non-dba
would be questions I'd want answered if I were working there.
|
|
|
|
| Re: database migration [message #148145 is a reply to message #147633] |
Tue, 22 November 2005 22:24 |
srinivas4u2
Messages: 66
Registered: June 2005
|
Member |
|
|
Mahesh,
Can you please explain how materialized views can be used to migrate a database from one O.S to another.
Re: database migration [message #147618 is a reply to message #147602 ] Fri, 18 November 2005 10:54
Mahesh Rajendran
Messages: 5231
Registered: March 2002 Senior Member add to buddy list
ignore all messages by this user
There are only two options available.
Export and import
or
using materialized views.
In your case, exporting the source and importing into target is the simplest way.
|
|
|
|
| Re: database migration [message #148207 is a reply to message #148145] |
Wed, 23 November 2005 01:37 |
ndefontenay
Messages: 14
Registered: November 2005
Location: Thailand
|
Junior Member |
|
|
If you are non-DBA then it may be good to know that you should create the tablespaces with the exact name existing in your solaris environment.
If you don't create the tablespaces then when you import it in Linux all your objects will go in your system tablespace by default and this is really serious problem.
If you are not able to create the tablespace on your own then it may be a good idea to ask someone else to perform the task. Export/Import is easy but not that easy if you are not DBA.
|
|
|
|
| Re: database migration [message #148380 is a reply to message #148207] |
Wed, 23 November 2005 20:57 |
srinivas4u2
Messages: 66
Registered: June 2005
|
Member |
|
|
Thanks for your response! But that doesn't answer my question.
I want to know how one can migrate a database from one O.S to another O.S using materialized views. This was one of the suggestions made in the same thread. I am just curious to know how that can be done.
|
|
|
|
|
|
|
|
| Re: database migration [message #148906 is a reply to message #147602] |
Mon, 28 November 2005 23:51 |
ybrahma
Messages: 3
Registered: November 2005
|
Junior Member |
|
|
|
Hi, If you are using 10g there is another method to do is using RMAN convert command. for complete steps please refer to oracle's RMAN advanced users guide.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
