drop table from readonly TS

Hi,

• Question background :

My DB is in ArchiveLog mode.
I have TS in ReadOnly mode.
As i know,
- Oracle allows to DROP table resides in ReadOnly TS (& other objects also) even though that TS is in ReadOnly mode. - Oracle will not recover ReadOnly TS during Oracle startup.

I have backup of db files "after" making TS readOnly but "before" dropping tables from ReadOnly TS.
That means...

1st, made TS as ReadOnly
2nd, took backup of ReadOnly TS
3rd, dropped few tables from ReadOnly TS

• Question : After restore + recovery operation, those dropped table will be available or not ? WHY ? I am in doubt because 1) there is chance of having those tables BACK after restore + recovery operation because restored files are before dropping tables. 2) there is chance of NOT having those tables back after restore + recovery operation because Oracle doesn't perform recovery for ReadOnly TS.

Which one is correct ???

Thanks,
Darshak Received on Thu Jul 31 2003 - 13:11:02 CEST