Title: RE: Which index need rebuilding?
|
thankyou!!
You are correct; drop and recreate the tablespace
and don't do anything at UNIX level, as the contents of the logical volume
(a.k.a. raw device) will just be overwritten...
----- Original Message -----
Sent: Tuesday, August 13, 2002 7:38
AM
Subject: raw devices
Hi,
Wondering if anyone can help me with this question. Basically we have
a parallel server setup (solaris 2.8 oracle 8.1.7.3)and so are using raw
devices. I am in the process of recreating the tablspaces to be locally
managed as opposed to dictionary. My question is this: In a filesystem
environment, I would drop the tablespace in oracle and rm the corresponding
datafile on the unix level, and then I can go about recreating my
tablespace. I know that the OS doesnt really "interact" with the raw devices
as such, but, in this situation would I be able to drop the tablespace and
recreate it without having to do anything on the unix level? Would that
corresponding raw device just be overwritten??
Any help would be greatly appreciated
Rgds
Fawzia
**********************************************************************
Information
in this email is confidential and may be privileged.
It is intended for
the addressee only. If you have received it in error,
please notify the
sender immediately and delete it from your system.
You should not
otherwise copy it, retransmit it or use or disclose its
contents to
anyone.
Thank you for your
co-operation.
**********************************************************************
|
