Home » RDBMS Server » Backup & Recovery » Tablespaces in a different location
Tablespaces in a different location [message #165497] Thu, 30 March 2006 11:44 Go to next message
orant1
Messages: 28
Registered: June 2005
Junior Member
Hi,

I intend to recreate my database on testing server. Can I manualy create tablespaces on different locations (on testing server) and use full import of production database?

Thanks

Report message to a moderator

Re: Tablespaces in a different location [message #165500 is a reply to message #165497] Thu, 30 March 2006 12:30 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> use full import of production database?
Do user-by-user import by specifying fromuser/touser clause.

Report message to a moderator

Re: Tablespaces in a different location [message #165512 is a reply to message #165497] Thu, 30 March 2006 14:07 Go to previous messageGo to next message
orant1
Messages: 28
Registered: June 2005
Junior Member
And what about tablespaces, can i change location???

Names of tablespaces and datafiles would be the same as on production database.

Report message to a moderator

Re: Tablespaces in a different location [message #165521 is a reply to message #165512] Thu, 30 March 2006 15:14 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Yes. Just precreate the tablespace in whatever locations you want.
The tablespace does not even need to be in the same name ( if you use fromuser/touser option).

Report message to a moderator

Re: Tablespaces in a different location [message #165597 is a reply to message #165521] Fri, 31 March 2006 00:49 Go to previous messageGo to next message
madhusunkara
Messages: 59
Registered: March 2006
Location: hyderabad,india
Member
since it is a test server you can use the same username then you can drop fromuser/touser. depending upon the imp utilty version fromuser/touser may not work properly, for example imp utility that comes with 8.1.7.4 has problems

Thanks
Madhu

Report message to a moderator

Re: Tablespaces in a different location [message #166145 is a reply to message #165497] Tue, 04 April 2006 16:41 Go to previous message
orant1
Messages: 28
Registered: June 2005
Junior Member
Thanks for your suggestions, I create tablespaces on different places and full import suceeded without warnings. I preserve the same names as on production database.

Report message to a moderator

Previous Topic: export and import
Next Topic: Time based recovery?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 24 10:29:53 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.