Oh my! Phew! Ouch!
Please take a few minutes to provide feedback on the quality of service you received. The Department of Education values your feedback as a customer. Commissioner John L. Winn is committed to continuously assessing and improving the level and quality of services provided to you by Department staff. Simply use the link below. Thank you in advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: Chamberlain John
[mailto:oracledba-ezmlmshield-x62675754.[Email address protected]
Sent: Monday, April 03, 2006 3:24 AM
To: LazyDBA Discussion
Subject: RE: datafile dropped
...and don't forget the most important command:
Revoke dba from idiot_programmer;
Nuff said...
-----Original Message-----
From: Raymer Loren
[mailto:oracledba-ezmlmshield-x85215163.[Email address protected]
Sent: 02 April 2006 15:22
To: LazyDBA Discussion
Subject: RE: datafile dropped
# DROPPING TABLESPACE AFTER DATAFILES HAVE BEEN REMOVED
How to drop a tablespace when the datafile has already been removed from
the
OS....
SQL> select * from v$recover_file;
no rows selected
SQL> select * from dba_data_files where tablespace_name =
'SHP_SUMMARY_INDEX';
FILE_NAME
------------------------------------------------------------------------
----
--------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
--------- ------------------------------ --------- --------- ---------
/u11/oradata/whse/summary_index01.dbf
48 SHP_SUMMARY_INDEX 38797312 2368 AVAILABLE
SQL> ALTER DATABASE DATAFILE '/u11/oradata/whse/summary_index01.dbf'
OFFLINE
DROP;
Database altered.
SQL> ALTER TABLESPACE SHP_SUMMARY_INDEX OFFLINE;
ALTER TABLESPACE SHP_SUMMARY_INDEX OFFLINE
*
ERROR at line 1:
ORA-01191: file 48 is already offline - cannot do a normal offline
ORA-01110: data file 48: '/u11/oradata/whse/summary_index01.dbf'
SQL> ALTER TABLESPACE SHP_SUMMARY_INDEX OFFLINE IMMEDIATE;
Tablespace altered.
SQL> DROP TABLESPACE SHP_SUMMARY_INDEX;
Tablespace dropped.
SQL>
If the datafile is in recovery status, the instance will need to be
brought up in mount mode to
drop the datafile. Then open the database and drop the tablespace
1. From a server manager session stop the instance restart in mount
mode.
SVRMGRL> shutdown immediate
:
SVRMGRL> startup mount
2. From the server manager session, alter the datafiles offline and
drop.
SVRMGRL> alter database datafile '[full pathed datafile name]' offline
drop;
3. Open the database
SVRMGRL> alter database open;
4. Drop the tablespace
SVRMGRL> drop tablespace [target tablespace];
-----Original Message-----
From: Abdul Wahab Ansari
[mailto:oracledba-ezmlmshield-x64371139.[Email address protected]
Sent: Sunday, April 02, 2006 6:31 AM
To: LazyDBA Discussion
Subject: datafile dropped
Hello
One programmer misused his rights and dropped a datafile without
dropping the tablespace. How can we drop the tablespace
Now?
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
----------------------------------------------------------------------------
--
This email is confidential and may be legally privileged.
It is intended solely for the addressee. Access to this email by anyone
else, unless expressly approved by the sender or an authorized addressee, is
unauthorized.
If you are not the intended recipient, any disclosure, copying, distribution
or any action omitted or taken in reliance on it, is prohibited and may be
unlawful. If you believe that you have received this email in error, please
contact the sender, delete this e-mail and destroy all copies.
============================================================================
==
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
-----------------------------------------
Information in this email may be privileged, confidential and is
intended exclusively for the addressee. The views expressed may not
be official policy, but the personal views of the originator. If
you have received it in error, please notify the sender by return
e-mail and delete it from your system. You should not reproduce,
distribute, store, retransmit, use or disclose its contents to
anyone.
Please note we reserve the right to monitor all e-mail
communication through our internal and external networks.
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page