drop table from readonly TS

Darshak Shah

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
Assume now media failure occurred.

* 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

Jul 19 '05 #1

Subscribe Post Reply

4292

sybrandb

da******@coreobjects.com (Darshak Shah) wrote in message news:<92**************************@posting.google. com>...

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
Assume now media failure occurred.

* 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

Information about tables is maintained in the datadictionary in the
system tablespace. The affected tables have been deleted from the
dictionary.
And NO you will not get them back EVER. Not recovering read only
tablespaces has NOTHING to do with it.

Sybrand Bakker
Senior Oracle DBA

Jul 19 '05 #2

Karsten Schmidt

sy******@yahoo.com wrote in message news:<a1**************************@posting.google. com>...

da******@coreobjects.com (Darshak Shah) wrote in message news:<92**************************@posting.google. com>...
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
Assume now media failure occurred.

* 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

Information about tables is maintained in the datadictionary in the
system tablespace. The affected tables have been deleted from the
dictionary.
And NO you will not get them back EVER. Not recovering read only
tablespaces has NOTHING to do with it.

Sybrand Bakker
Senior Oracle DBA

Hi,
actually this is kind of interesting - I think.
If this tablespace is local managed, Oracle would have to update the
free space bitmaps in the 'read only' datafiles, i.e. they change.
Thus a new backup would be required.

I did nt't test this, but i doubt that it would be allowed to drop
tables from read-only local managed tablespaces.

Karsten

Jul 19 '05 #3

by: daveland | last post by:

I am working on some JavaScript that dynamically adds rows to a table in response to a button click. A new row does appear on the screen when the button is clicked. However, that table to which a...

Javascript

readOnly attribute doesn't work for drop down list?

by: Matt | last post by:

I want to know if readOnly attribute doesn't work for drop down list? If I try disabled attribute, it works fine for drop down list. When I try text box, it works fine for both disabled and...

Javascript

DataGrid using a table not a DataSet

by: Leo | last post by:

Thanks for the Help in Advance! I am a beginner in VB.Net. I am trying to create a form which is displayed in a email for our customers to fill in a Request for quote. I would like them to type...

ASP.NET

Populate Table using Dataset

by: Junior | last post by:

Hi All, I haven't got a response for this question lately and i really need to get this done ASAP. I have a .aspx page that has table two column four rows on it. 1. How do i use codebehind C#...

C# / C Sharp

table added dynamically to div span on ie doesn't appear

by: James Black | last post by:

I am dynamically generating a table in IE to display some information. I will probably change it to divs later, but I just want to get it working properly first. In my div I have the following...

Javascript

table added to div doesn't appear when using IE

by: James Black | last post by:

I am dynamically generating a table in IE to display some information. I will probably change it to divs later, but I just want to get it working properly first. In my div I have the following...

Javascript

How to get an array of table data into multiple text box elements

by: jonniethecodeprince | last post by:

Hi all, I have trouble getting an array of data stored in a separate javascript file i.e. a file called books.js into a table of data for a .xhtml file. There are 50 Records in this file....

Javascript

drop table from readonly TS

by: Darshak Shah | last post by:

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...

Oracle Database

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

drop table from readonly TS

Similar topics