Purge table yog dab tsi?
Purge table yog dab tsi?

Video: Purge table yog dab tsi?

Video: Purge table yog dab tsi?
Video: 3 yam uas ua rau peb swb dab yog dab tsi tiag 2024, Kaum ib hlis
Anonim

PURGE . Lub hom phiaj. Siv cov PURGE nqe lus kom tshem tawm a rooj los yog ntsuas los ntawm koj lub recycle bin thiab tso tag nrho cov chaw uas txuam nrog cov khoom, los yog tshem tawm tag nrho cov recycle bin, los yog tshem tawm ib feem ntawm tag nrho cov poob tablespace los ntawm lub recycle bin.

Tib neeg kuj nug, nws txhais li cas los ntxuav cov ntaub ntawv?

Kev tshem tawm cov ntaub ntawv yog ib lo lus uas feem ntau siv los piav txog txoj hauv kev uas tshem tawm mus tas li thiab tshem tawm cov ntaub ntawv los ntawm qhov chaw cia khoom. Kev tshem tawm feem ntau pom tias yog qhov kev nyiam ib ntus, whereas kev tshem tawm tshem tawm cov cov ntaub ntawv mus tas li thiab qhib lub cim xeeb lossis chaw cia rau lwm yam kev siv.

Qhov thib ob, kuv yuav ntxuav lub rooj hauv Oracle li cas? Thaum muab DROP TABSIS nqe lus hauv Oracle , koj tuaj yeem teev cov PURGE kev xaiv. Cov PURGE kev xaiv yuav tshem tawm tus rooj thiab nws cov khoom nyob rau hauv thiaj li hais tias lawv tsis tshwm sim nyob rau hauv lub recycle bin. Kev pheej hmoo ntawm kev qhia txog qhov PURGE kev xaiv yog tias koj yuav tsis muaj peev xwm rov qab tau cov rooj.

Yog li ntawd, qhov txawv ntawm kev tshem tawm thiab tshem tawm yog dab tsi?

Rho tawm tshem cov kab mus. Piv txwv li, yog tias koj muaj cov kab ua haujlwm, thiab cov haujlwm yuav ua tiav tom qab kab ntawv, koj tuaj yeem ua tau rho tawm cov kab no vim lawv tsis xav tau ntxiv lawm. Kev tshem tawm yog tus txheej txheem ntawm kev tso chaw hauv database los yog rho tawm obsolete cov ntaub ntawv uas tsis xav tau los ntawm lub system.

Puas poob lub rooj pub dawb qhov chaw Oracle?

Tsuas yog koj qhia tus PURGE clause, DROP TABLE nqe lus ua tsis ua rau qhov chaw raug tso rov qab rau tus tablespace siv los ntawm lwm yam khoom, thiab qhov chaw tseem suav rau tus cov neeg siv qhov chaw quota. Rau sab nraud rooj , nqe lus no tshem tawm xwb lub rooj metadata hauv tus database.

Pom zoo: