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;
SQL> spool crsidx.sql
SQL> select 'DROP INDEX ' || i.index_name || ';'
from dba_indexes i
where tablespace_name = 'PCQ_IDX' ;
SQL> select 'CREATE INDEX ' || c.index_name || ' ON ' ||
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/
