Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DELETE A DATAFILE

505694Apr 20 2006 — edited Oct 28 2011
HOW I DELETE A DATAFILE
ADMINISTRATOR GUIDE SAYS THERE'S NO SQL COMMAND TO DELETE A DATAFILE
1. SO U HAVE TO CREATE A TABLESAPCE
2. ADD THAT DATAFILE TO IT
3. DELETE the talespace with option 'including datafiles'

but when i try to add that datafile to a newly cretaed tablespace
i recieve an error says, "the datafiel is part of the database'

thnx for the help
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 25 2011
Added on Apr 20 2006
15 comments
85,052 views