OraFAQ Forum: Server Utilities » Trasporting data between servers

Home » RDBMS Server » Server Utilities » Trasporting data between servers

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Trasporting data between servers [message #261223]

Wed, 22 August 2007 03:15

majstoru
Messages: 68
Registered: October 2006
Location: Serbia

Member

Hi,

Here is small newbie question about transfering data between two servers (or between to pc which have installed oracle).

I have installed Oracle 10g on my server which is main server in company where I develop IS. So I don't like to test my app on real data because I have somethime some bug and that will be corrupt data which is allredy in database, and I would like, if it is possible to copy tablespaces and logfiles into my develop PC with same Oracle installation like server.

Is this scenario possible and what files are needed for this operation?

Thanks...

Report message to a moderator

Re: Trasporting data between servers [message #261231 is a reply to message #261223]

Wed, 22 August 2007 03:25

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Search about this topic in this forum. Many question are came about cloning database.

Report message to a moderator

Re: Trasporting data between servers [message #261238 is a reply to message #261223]

Wed, 22 August 2007 03:42

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

export/import and/or transportable tablespaces.

Regards
Michel

Report message to a moderator

Re: Trasporting data between servers [message #261253 is a reply to message #261238]

Wed, 22 August 2007 03:59

majstoru
Messages: 68
Registered: October 2006
Location: Serbia

Member

Hi Michael,

This tip with transportable tablespaces sounds good, do you have some link to some document which is fully describe this theme?

Thanks

Report message to a moderator

Re: Trasporting data between servers [message #261281 is a reply to message #261253]

Wed, 22 August 2007 04:50

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

http://www.oracle.com/pls/db102/search?remark=quick_search&word=transportable+tablespace&tab_id=&format=ranked

Regards
Michel

Report message to a moderator

Re: Trasporting data between servers [message #261293 is a reply to message #261223]

Wed, 22 August 2007 05:02

ebrian
Messages: 2794
Registered: April 2006

Senior Member

A rather seamless way to perform this would also be to utilize RMAN's DUPLICATE feature.

Report message to a moderator

Previous Topic:	SQL Loader - needs to load , (comma) from , (Comma) separated file
Next Topic:	How to migrate from Oracle 8i to Oracle 10g with 100GB Data?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 09:50:16 CST 2024