Home » RDBMS Server » Server Administration » database migration using transportable tablespace
database migration using transportable tablespace [message #234632] Wed, 02 May 2007 13:32 Go to next message
orcl dba
Messages: 68
Registered: August 2005
Member
We have an Oracle database 10g on a Solaris system which we would like to migrate to Linux SLES10. We are planning to use the transportable tablespace method for the migration. My question is this: Before we plug in the tablespaces from the source to the target, we have to create a database on the target with the same structure as the source. What export/import command line should be used to perform the export/import to create the database? It's really urgent. An early response would be really appreciated.

Thanks

Report message to a moderator

Re: database migration using transportable tablespace [message #234640 is a reply to message #234632] Wed, 02 May 2007 13:40 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14231/tspaces.htm#i1007252

>> It's really urgent. An early response would be really appreciated.
If it is urgent, call oracle support.
This is just a forum.

Report message to a moderator

Re: database migration using transportable tablespace [message #234642 is a reply to message #234640] Wed, 02 May 2007 13:57 Go to previous messageGo to next message
orcl dba
Messages: 68
Registered: August 2005
Member
The document mentions procedure about plugging in the tablespaces. It gives little information about creating the database.
Anyways thanks for the reply.

Report message to a moderator

Re: database migration using transportable tablespace [message #234643 is a reply to message #234642] Wed, 02 May 2007 14:01 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
export/import will Not create the database.
You create the target database.
Export source.
Import into target.
In your case, you are looking into transportable tablespaces.
Create a database.
Export target tablespaces as said in document.
Import it as said in document.

Report message to a moderator

Re: database migration using transportable tablespace [message #234645 is a reply to message #234643] Wed, 02 May 2007 14:05 Go to previous messageGo to next message
orcl dba
Messages: 68
Registered: August 2005
Member
Transportable tablespaces cannot transport system tablespace.

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14231/tspaces.htm#i1007233

Is there anyway to transfer the system objects?

[Updated on: Wed, 02 May 2007 14:06]

Report message to a moderator

Re: database migration using transportable tablespace [message #234646 is a reply to message #234645] Wed, 02 May 2007 14:07 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> Is there anyway to transfer the system objects?
You do not want to do that.
YOu may need to transfer the data(user objects). Not the system objects.
If you are worried about the code (stored procedures etc) use other means (regular code exp/expdp/dbms_metadata to extract ddl etc).
It is imperative not to export system objects in system tablespace.

[Updated on: Wed, 02 May 2007 14:12]

Report message to a moderator

Previous Topic: ORA-03113
Next Topic: Installing Oracle 10g and 9i on same systems
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Feb 25 06:31:57 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.