Cum la spre Remove �i Drop Datafiles de la Tablespace �n�untru Oracle Baz� de date

Oracle RDBMS baz� de date magazin date logically �n format de tablespaces �i physically �n format de date dosar. Art.hot. datafiles e�ti added la tablespaces as baz� de date perioad� requirement grows mai mare. Totu�i, acolo e�ti mai mul�i reasons tu po�i nevoie la spre remove sau a �terge date dosar de la un tablespace. Such as accidentally a aduna un gre�eal� sized sau unwanted datafile la spre un tablespace, sau art.hot. date perioad� usage has fiindc� mai mic �i ni�te date dosar nevoie la spre a fi removed, sau a �nso�i la spre a nota Oracle baz� de date care fails la spre scrobeal� datorie la spre misiune sau corrupted datafiles by removing pe ei, Oracle does nu provide un simplu way sau user interface la spre a �terge sau drop datafiles de la un tablespace. O dat� un datafile is made part de un tablespace, it a putea nu lung a fi detached sau removed de la tablespace, albeit acolo e�ti mai mul�i workarounds.

Cum la spre Completat Drop art.hot. �ntreg Tablespace cu Tot Datafiles

Art.hot. easiest way la spre drop un sau multiple datafiles is by dropping art.hot. entire tablespace together cu s�u datafiles. Dac� tu nu lung nevoie art.hot. date contents de la tablespace, art.hot. a urma virgul� voin�� a voi drop art.hot. tablespace, art.hot. datafile, �i art.hot. tablespaces’ contents de la date dic�ionar. Tot de la objects that unde contained �n�untru that tablespace e�ti permanent removed.

DROP TABLESPACE <tablespace nume> A CUPRINDE CONTENTS �I DATAFILES;

Dac� tu dont’ special “ �i DATAFILES”, Oracle voin�� a voi nu drop art.hot. physical datafile dup� art.hot. DROP TABLESPACE virgul�, numai tu po�i always a �terge art.hot. dosar de la opera�ie sistem raft ( dac� art.hot. date dosar e�ti �ncuiat, pauz� art.hot. a servi).

Numai always parfum un spate de la baz� de date, as art.hot. “DROP TABLESPACE” virgul� is irreversible. S�u’ de asemenea un bun practice la spre a verifica �i identify cum mul�i datafiles un tablespace actually has �nainte performing art.hot. drop action �n�untru ordine la spre avoid mistake.

Cum la spre A verifica Cum Mul�i Datafiles un Tablespace Has

La spre determinat �i identify tot datafiles that link la spre un tablespace, folos art.hot. a urma �ntrebare, cu tablespace nume �n�untru capital liter�:

SELECT file_name, tablespace_name
DE LA dba_data_files
UNDE tablespace_name =’<tablespace nume>’;

Dac� un tablespace contact multiple datafiles, �i tu chiar nevoie la spre drop unul sau ni�te de la datafiles �i a p�stra art.hot. remaining datafiles together cu art.hot. objects �i contents, art.hot. objects sau date musta�� a fi exportat pentru art.hot. a afecta mas� perioad�. O dat� exportat, art.hot. tablespace a putea a fi dropped cu above “DROP TABLESPACE” virgul�. Apoi atunci, recreate art.hot. tablespace cu art.hot. datafiles() a cere (that tu initially nevoie la spre a p�stra), �i apoi atunci import art.hot. objects into art.hot. recreated tablespace.

Dac� unul sau mai mult datafiles is misiune dup� un recovery proces sau accident a �terge, tu po�i folos ALTER BAZ� DE DATE DATAFILE <datafile nume> OFFLINE DROP virgul� la spre a face art.hot. datafile offline so that baz� de date a putea scrobeal� sus dup� care art.hot. troubled tablespace a putea a fi dropped. (a vedeainstruc�iuni la spre a nota de la misiune datafiles.)

Cum la spre Resize un Datafile la spre Minimum Size

Alt alternator la spre drop art.hot. datafile is by shrinking art.hot. size de datafile �n schimbul dropping. This op�iune is unic posibil dac� acolo is nu prelungire �n datafile. Dac� acolo e�ti nici unul, s�u’ posibil la spre resize art.hot. date dosar jos la spre un foarte mic dosar (2 butuc), unde Oracle baz� de date voin�� a voi nu lung a crea orice prelungire �n datafile. Totu�i, this workaround does nu remove art.hot. datafile de la tablespace nici a �terge art.hot. dosar physically, numai it reduce art.hot. risc as nu date voin�� a voi a fi truncated as unic empty butuc e�ti reduced. It simplu a face it unusable �i a lua sus aproape �nchis la spre nu disc perioad�. La spre resize un datafile, folos art.hot. a urma �ntrebare:

alter baz� de date datafile ‘<datafile nume>’ resize 8M;

Cum la spre Determinat art.hot. Prelungire interior Datafile

La spre a verifica �i determinat art.hot. prelungire that exists �n�untru un datafile, folos this �ntrebare:

SELECT proprietar, segment_name
DE LA dba_extents un, dba_data_files b
UNDE a.file_id = b.file_id
�I b.file_name = ‘<datafile nume>’

import: Aceasta este o machine a traduce pagin� care is provided "as is" f�r� warranty. Machine traducere Mai a fi difficult la spre understand. A face pe plac la refer la spreorigine Englez anghinar� oric�nd posibil.

Share �i contribute sau a lua technical cin� �i ajutor laMeu Digital Via�� Forums.

Rela�ii Anghinar�

• Cum Drop Tablespace �i A nota Oracle Baz� de date C�nd Accidentally A �terge Datafile
• Cum la spre Rename sau A mi�ca Oracle Tablespace Datafile la spre Alt A localiza
• ORA-25153 Temporary Tablespace is Empty Error �n�untru Oracle
• Oracle ORA-01658 Incapabil la spre A crea INITIAL Prelungire pentru Segment �n�untru Tablespace Error
• A �terge, Remove sau Drop Oracle Magazin Pachet cu Drop Pachet
• Oracle Baz� de date Link
• ORA-02449 Oracle Drop Mas� Error
• Oracle Baz� de date Import Error 3113/3114
• Scimbare Oracle Baz� de date User Password
• A verifica Oracle Traducere

This intrare was post on S�mb�t�, August 4th, 2007 la 1229: s�nt �i is dosar josBaz� de date. Tu po�i a urma orice r�spuns la spre this intrare g�t art.hot.RSS 2.0 feed. Tu po�iplecare un r�spuns,sau trackback de la al t�u own site.