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.