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

Deleting physical datafiles from inside Oracle8i

How do I delete physical datafile from inside Oracle? I am handling an Oracle8i database from the client machine. I have to drop the Oracle Tablespace. When I drop the tablespace, the physical file should also delete from the operating system folder. What is the procedure, without going to operating system deletion command?

In Oracle 8i and before, you cannot drop the datafile(s) automatically when you drop a tablespace. You must use OS delete commands on the server after you have dropped the tablespace. This is a big pain, isn't it? Oracle has promised that the DROP TABLESPACE command in Oracle 9i will contain a clause which will let you drop the datafiles at the same time the tablespace is dropped. But until you migrate to Oracle 9i, you will be stuck with server-side OS delete commands.

For More Information


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