Home » RDBMS Server » Server Administration » extra space in file_location for alter command
extra space in file_location for alter command [message #481870] Sun, 07 November 2010 23:06 Go to next message
chuikingman
Messages: 90
Registered: August 2009
Member
Hi,
I do below alter command
alter tablespace RCA_MB_IDX add datafile '/gxsdb/database/oradata5/RCA/RCA_REF_MB_IDX_01.dbf ' size 1024M

But there is extra space in the file location '/gxsdb/database/oradata5/RCA/RCA_REF_MB_IDX_01.dbfX'
I mark X for that space ...

The command is commit .

But there is problem when do backup ...as the file cannot be find since there is extra space after ".dbf"
How can I fall back ???
Any idea how I can fix it ????

Report message to a moderator

Re: extra space in file_location for alter command [message #481877 is a reply to message #481870] Mon, 08 November 2010 00:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ALTER DATABASE RENAME FILE ...
and also rename it at OS level.

Regards
Michel

[Updated on: Mon, 08 November 2010 00:19]

Report message to a moderator

Re: extra space in file_location for alter command [message #486479 is a reply to message #481877] Wed, 15 December 2010 21:04 Go to previous messageGo to next message
vnkumaresh
Messages: 9
Registered: December 2010
Junior Member
You have to take the tablespace offline.
Then in OS level mv fileX* file
Then do the alter tablespace rename in DB level
Take the tablespace online.

Thanks

Report message to a moderator

Re: extra space in file_location for alter command [message #486495 is a reply to message #486479] Thu, 16 December 2010 01:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Taking offline just the file is necessary not the whole tablespace.

Regards
Michel

Report message to a moderator

Re: extra space in file_location for alter command [message #486496 is a reply to message #486495] Thu, 16 December 2010 01:21 Go to previous message
vnkumaresh
Messages: 9
Registered: December 2010
Junior Member
If you take tablespace ofline, Then it will not prompt for recovery while taking back online. But if you are taking offline the file alone, it will ask for online recovery. Thats why i suggested to take tablespace offline

Thanks

Report message to a moderator

Previous Topic: Unable to grant SELECT priv to ROLE
Next Topic: ASM File size
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 11 13:35:04 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.