OraFAQ Forum: Server Utilities » change datafile address

Home » RDBMS Server » Server Utilities » change datafile address

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

change datafile address [message #277215]

Mon, 29 October 2007 04:41

allahmorad
Messages: 18
Registered: June 2006

Junior Member

Hi,

How to change datafile address in dump file?

best regard
allahmodar

Report message to a moderator

Re: change datafile address [message #277238 is a reply to message #277215]

Mon, 29 October 2007 05:22

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

Senior Member
Account Moderator

Use a pen. Razz

You mean an export dump file, you can't.

Regards
Michel

[Updated on: Mon, 29 October 2007 05:23]

Report message to a moderator

Re: change datafile address [message #277255 is a reply to message #277238]

Mon, 29 October 2007 05:52

allahmorad
Messages: 18
Registered: June 2006

Junior Member

tnx
I take Full export from my database on server A that datafile is in E:\testDB Address
but in Server B i dont have E drive only C and D Drive,
can i import this dump file

regards
allahmorad

Report message to a moderator

Re: change datafile address [message #277261 is a reply to message #277255]

Mon, 29 October 2007 05:55

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

Senior Member
Account Moderator

I this case, you have to precreate the tablespaces before importing.

Regards
Michel

Report message to a moderator

Re: change datafile address [message #277264 is a reply to message #277261]

Mon, 29 October 2007 06:12

allahmorad
Messages: 18
Registered: June 2006

Junior Member

thank you very much.

allahmorad

Report message to a moderator

Previous Topic:	SQL Loader and partitioned indexes
Next Topic:	what happened when cange data during take export

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 00:05:05 CST 2024