Home » RDBMS Server » Server Administration » tablespace related
tablespace related [message #313214] Fri, 11 April 2008 01:39 Go to next message
sidd_411
Messages: 30
Registered: March 2008
Member
Hi all,

I just want to know can I create tablespace in any other location other than default

Report message to a moderator

Re: tablespace related [message #313231 is a reply to message #313214] Fri, 11 April 2008 02:55 Go to previous messageGo to next message
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
Senior Member
Yes

Report message to a moderator

Re: tablespace related [message #313264 is a reply to message #313214] Fri, 11 April 2008 05:01 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Yes you can.

create tablespace tabsp datafile 'any location'..;

Report message to a moderator

Re: tablespace related [message #313356 is a reply to message #313214] Fri, 11 April 2008 08:30 Go to previous message
sidd_411
Messages: 30
Registered: March 2008
Member
thanks a lot

Report message to a moderator

Previous Topic: Reason of Error ORA-07445: exception encountered: core dump [kgghstfel()+15] [SIGSEGV] [Address not
Next Topic: not null
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 21:37:31 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.