Home » RDBMS Server » Server Administration » Alter tablespace issue (oracle 11.2.0.1 )
Alter tablespace issue [message #611301] Tue, 01 April 2014 03:07 Go to next message
sathish16787
Messages: 56
Registered: September 2011
Location: mumbai
Member
Altered tablespace with adding datafile with below command.

Alter tablespace XXX '/u02/oradata/test/tre_05.dbf' size 25;(created successfully)
Alter tablespace XXX '/u03/oradata/test/tre_05.dbf' size 25;

second datafile is not added when i queried dba_data_files. But in os datafile is created and size occupied. in trace file ORA-604 signalled during: Alter tablespace getting the error.

if the datafile is not craeted .can we drop the datafile using os command on location /u03/oradata/test/tre_05.dbf.

will it affect when bounce the database.

please help . thanks in advance.
Re: Alter tablespace issue [message #611309 is a reply to message #611301] Tue, 01 April 2014 03:31 Go to previous messageGo to next message
John Watson
Messages: 4687
Registered: January 2010
Location: Global Village
Senior Member
One cannot assist if you do not describe, correctly,what happened. Your code does not run:
orclz> Alter tablespace XXX '/u02/oradata/test/tre_05.dbf' size 25;
Alter tablespace XXX '/u02/oradata/test/tre_05.dbf' size 25
                     *
ERROR at line 1:
ORA-02142: missing or invalid ALTER TABLESPACE option


orclz>

Re: Alter tablespace issue [message #611313 is a reply to message #611309] Tue, 01 April 2014 03:46 Go to previous messageGo to next message
sathish16787
Messages: 56
Registered: September 2011
Location: mumbai
Member
Alter tablespace XXX add datafile '/u02/oradata/test/tre_05.dbf' size 25g ;( this datafile created successfully)

Alter tablespace XXX add datafile '/u03/oradata/test/tre_05.dbf' size 25g ; (this is not created)

when i checked dba_data_files /u03/oradata/test/tre_05.dbf is not created but when i checked in os level datafile file present on that location . can we drop the datafile on os level on location /u03/oradata/test/tre_05.dbf. this db is running in noarchive log mode.


Re: Alter tablespace issue [message #611319 is a reply to message #611313] Tue, 01 April 2014 04:36 Go to previous message
John Watson
Messages: 4687
Registered: January 2010
Location: Global Village
Senior Member
I have no idea what your situation is.

What happened when you ran those commands?
How did you "checked dba_data_files" ?
How did you "checked in os level datafile file present" ?

Please understand that I cannot see your computer screen. Use copy/paste to show all your commands, enclosing them in [code] tags as I did in my example.
Previous Topic: ORA-01033 ORACLE initiation or shutdown in progess
Next Topic: Oracle database migration at OS level
Goto Forum:
  


Current Time: Fri Oct 24 05:23:04 CDT 2014

Total time taken to generate the page: 0.15356 seconds