Database Administration (MOSC)

MOSC Banner

Dropping Tablespaces whith deleted datafiles via OS

edited Aug 3, 2009 7:54PM in Database Administration (MOSC) 4 commentsAnswered
Hi!

I am trying to drop a tablespace which had two associated datafiles. The problem is that the two datafiles of this tablespace were deleted (in a  HP_UX server) and I am not able to recover them. When I try the "Drop tablespace" command I get an error because it is trying to read the missing files. If I create the two files with an arbitrary content it does not work as it states an I/O error. How could I drop the tablespace ? Thanks

A.P.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center