terimakasih pak Bowo atas sharing ilmunya , namun kebetulan jawabannya agak
terlambat , sy telah lakukan dengan cara yang sama dengan pak Bowo. kmrn
karena urgen banget sy langsung cari di website dan alkamduliah ketemu..
thank
salam
================================
Agung Purwanto
IT. Team
-------Original Message-------
From: Yulius Wibowo
Date: 10/14/05 11:27:48
To: [email protected]
Subject: [indo-oracle] Re: Tolong problem di tablespace
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
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/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/
