(Revised)
>
> 1. Anda punya backupnya Pak ?
> Kalau ya, restore dan recover datafile-nya.
>
> 2. Alternatif lain, drop seluruh index yg ada di tablespace dari
> datafile yg bermasalah, kemudian buat lagi indexnya di tablespace
yg
> lain, yg available. Setelah itu bisa di drop tablespace yg
> bermasalah.
>
> SQL> select index_name, table_name
> from dba_indexes
> where tablespace_name = 'PCQ_IDX';
>
> SQL> CREATE TABLESPACE PCQ_IDX2 DATAFILE '....' SIZE xxxM;
======================
Tambahkan owner-nya
======================
> SQL> spool crsidx.sql
> SQL> select 'DROP INDEX ' || i.owner || '.' || i.index_name || ';'
> from dba_indexes i
> where tablespace_name = 'PCQ_IDX' ;
>
> SQL> select 'CREATE INDEX '|| c.index_owner|| '.' || c.index_name
|| ' ON ' || c.index_owner|| '.' ||
> c.table_name || '(' || c.column_name || ') TABLESPACE PCQ_IDX2;'
> from dba_indexes i, dba_ind_columns c
> where tablespace_name = 'PCQ_IDX'
> AND i.index_name = c.index_name
> AND i.owner = c.index_owner;
>
> SQL> spool off
> SQL> @crsidx.sql
>
> CMIWW
>
> Bowo
>
>
>
>
>
>
> --- In [email protected], "agung purwanto" <[EMAIL PROTECTED]>
> wrote:
> >
> >
> > Minta tolong bantuan..
> > saya ada trouble di oracle server. dimana salah satu table sapce
> nya tidak
> > bisa di online
> > table space tersebut adalah table space index. jada applikasi
saya
> tidak
> > bisa insert / update data.
> > kalau kita alter tablespace pqc_index online ,pesennya begini
> > RA-01110: 30 ??? ??: '/data2/DB_INDEX/pqc_idx1.dbs.
> >
> > apa yang harus saya lakukan ya..
> >
> > tolong dong yang punya pengalaman sharing ilmunya ..
> >
> > terima kasih
> >
> > salam
> >
> > agung
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/PhFolB/TM
--------------------------------------------------------------------~->
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
