drop tablespace including contents (and datafiles not given)

[samdba]

Hi guys,

I dropped tablespace with the command 'drop tablespace ts01 including contents' but forgot to give 'and datafiles'. This TS had three datafiles. Then, I created it again using one of the existing datafiles with 'reuse' option. Now, there are three datafiles existing. One attached to the ts01 and two old ones.

1. Did I make a big mistake by not giving 'and datafiles' option?

2. Can I remove the other two old datafiles physically?

3. I have not bounced the DB after this. Will it give any errors on shutting/starting the DB?

I checked dba_data_files and create controlfile script, it shows only one current datafile attached to ts01.

Thanks in Adv for any help with this.

[ixion]

Hi guys,

I dropped tablespace with the command 'drop tablespace ts01 including contents' but forgot to give 'and datafiles'. This TS had three datafiles. Then, I created it again using one of the existing datafiles with 'reuse' option. Now, there are three datafiles existing. One attached to the ts01 and two old ones.

1. Did I make a big mistake by not giving 'and datafiles' option?

2. Can I remove the other two old datafiles physically?

3. I have not bounced the DB after this. Will it give any errors on shutting/starting the DB?

.

1. Only a mistake if you didn't intend to leave the datafiles.
2. Yes you can manually remove the datafiles.
3. No.

[samdba]

1. Only a mistake if you didn't intend to leave the datafiles.
2. Yes you can manually remove the datafiles.
3. No.

Thanks ixion. I feel much relieved now.