Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Datafile deleted, can I restart the database?

Status
Not open for further replies.
SpiritOfLennon

SpiritOfLennon

IS-IT--Management
Oct 2, 2001
250
GB
Hi,
Our IT manager has accidentally dropped a datafile. The schema that it relates to is inconsequential. Can I remove reference to this schema and restart the database?
 
Sort by date Sort by votes
Datafiles belong to tablespaces, not schemas. Dropping the schema will has no bearing here.
Is the database currently up or down?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Livia8
  • Locked
  • Question
Can deleted files/ directories (rm -r) be retrieved again?
Replies
6
Views
684
Livia8
Livia8
J
  • Locked
  • Question
Oracle iCare Gift & Loyalty Portlet - Setup and configurations.
Replies
0
Views
165
jandresHDS
J
rk68
  • Locked
  • Question
Data encryption in Oracle 19c
Replies
0
Views
358
rk68
rk68
kernal
  • Locked
  • Question
Extract string before the first "-" it finds and the space prior to the "-"
Replies
5
Views
519
carp
carp
torturedmind
  • Locked
  • Question
Week of the year
Replies
0
Views
321
torturedmind
torturedmind

Part and Inventory Search

Sponsor

Back
Top