OraFAQ Forum: Server Utilities » copy a datafile from one instance to another

Home » RDBMS Server » Server Utilities » copy a datafile from one instance to another

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

copy a datafile from one instance to another [message #72048]

Wed, 26 February 2003 11:20

mark judd
Messages: 2
Registered: May 2002

Junior Member

i would like to do a unix copy of a production datafile to a test datafile so that the test datafile will look exactly like production.

all documentation says to do an export/import. why can i not just copy the file. what specifically is in the file that could interfer with the data on the test side?

the table definition(s), and table space definitaion and even datfile definition are the same except for the actual unix filename. the internal oracle datfile number thingys (reall technical there) might be and probably are different.

could some one educate me or point me in a direction

thanks

Report message to a moderator

Re: copy a datafile from one instance to another [message #72049 is a reply to message #72048]

Wed, 26 February 2003 11:39

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

several or one datafile makes  a tablespace.
when records are written to table , in the background, oracle looks for which tablespace is assinged and writes to any available datafile that the tablespace has.
thus table and tablespace are logical.
Datafile is physical.
there is no way to see, which table's record is in which datafile~!.
all u can map is tables and their tablespaces only.
Internally oracle maintains lotsa integrity.
so you cannot plug and play with a single datafile.
But if have transportable tablespaces defined,
then u can unplug it ( from the source) and plug it in(destination).

Report message to a moderator

Re: copy a datafile from one instance to another [message #72094 is a reply to message #72048]

Thu, 06 March 2003 15:29

Mike
Messages: 417
Registered: September 1998

Senior Member

try it out and you will see that it doesnt work.

The best way to clone a database is how Mahesh Rajendran explained it.

Report message to a moderator

Previous Topic:	Export view
Next Topic:	Direct path

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 11 09:36:59 CST 2025