OraFAQ Forum: Server Administration » Badly named tablespace ( 'tblsp1.ora')

Home » RDBMS Server » Server Administration » Badly named tablespace ( 'tblsp1.ora')

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

Badly named tablespace ( 'tblsp1.ora') [message #124023]

Wed, 15 June 2005 18:53

archs
Messages: 1
Registered: June 2005

Junior Member

I created a badly named tablespace 'tblsp1.ora'. Since it has a dot (.) in the name Oracle is unable to recognize it for either rename or drop tablespace command.
How can I get rid of this tablespace?

Report message to a moderator

Re: Badly named tablespace ( 'tblsp1.ora') [message #124024 is a reply to message #124023]

Wed, 15 June 2005 19:02

DMcG
Messages: 51
Registered: May 2005
Location: Auckland, New Zealand

Member

Try enclosing the tablespace name in double quotes - and make sure you get the case right -

"TBLSP1.ORA" (assuming it is upper case)

Dougie McGibbon

Report message to a moderator

Previous Topic:	ora-25150
Next Topic:	size of redolog?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 07:40:23 CST 2025