Q
Problem solve Get help with specific problems with your technologies, process and projects.

Trouble adding datafile to database

I'm just trying to add a 2 GB datafile to one of our data warehouse databases. It's on a Unix box. Before the operation finished, I accidentally pressed ctrl c after entering the command:

'ALTER TABLESPACE "OLOAS_DATA" 
 ADD
DATAFILE '/u47/oradata/bisu/dfile/.dbf'  SIZE  2097152K'

Consequently the 2 GB file is on the server but it cannot be seen in the dba_data_file view. What can I do to clean this up and re-enter the command again. It's a production 24x7 database so I can't take anything down.
When you pressed CTL-C, you aborted the ADD DATAFILE command. As such, this datafile is not part of the database. This is verified by the abscence of this datafile in the DBA_DATA_FILES view. Since this file is not part of the database, you can safely delete this file with OS commands and issue the above command again.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close