Ngenkathi uphatha isizindalwazi se-Oracle, isici esisodwa esibalulekile okufanele siqashwe indawo yetafula. Indawo yethebula iyindawo eyinhloko yokugcina idatha ngaphakathi kwesizindalwazi, futhi igcina amafayela edatha yomsebenzisi. Uma isikhala siphethwe kabi, izinkinga zokusebenza zingenzeka, okuholela emaphutheni angaba khona kanye nokwehluleka kwemisebenzi. Ukuqonda nokuphatha kahle isikhala setafula kuyingxenye ebalulekile yemisebenzi yonjiniyela we-Oracle SQL.
Ukuphatha indawo yetafula kuhlanganisa imisebenzi ehlukahlukene, njengokwenza izikhala zetafula ezintsha, ukushintsha ezikhona kakade, nokususa lezo ezingasadingeki. Ake sihlole ukuthi ungayenza kanjani le misebenzi ngempumelelo.
- Ukwakha indawo yetafula
DALA TABLESPACE table_space_name
DATAFILE 'datafile_path' SIZE usayizi;
- Ukushintsha indawo yetafula
ALTER TABLESPACE table_space_name ENGEZA IDATHAFILE 'datafile_path' SIZE usayizi;
- Ukuwisa isikhala setafula
YEHLISA TABLESPACE table_space_name;
Ukuqonda i-Oracle SQL Table Space
Indawo yetafula ye-Oracle SQL iyiyunithi yokugcina enengqondo ngaphakathi kwesizindalwazi. Iqukethe amasegimenti akhiwe ngama-degrees, wona akhiwa amabhulokhi wedatha. Abasebenzisi abasebenzisani ngokuqondile nesikhala setafula, kodwa bafinyelela idatha egcinwe ezindaweni zethebula.
Uma sihlelwa ngendlela, isikhala setafula singathuthukisa kakhulu isivinini sokubuyisa idatha, okuholela ekusetshenzisweni kwesizindalwazi ngokuphumelelayo. Ukunikeza isikhala esanele samathebula kusiza ukuvimbela izinkinga ezifana nenkohlakalo yedatha, ukulahleka kwedatha, noma ukuphahlazeka kwesistimu.
Ukuqapha Nokuphatha Isikhala Sethebula
Imiyalo eminingi eyakhelwe ngaphakathi ye-Oracle isiza ekuqapheni isikhala setafula. I-Oracle Database SQL Language Reference inikeza uhlu olubanzi lwale miyalo. Ivumela ukuphathwa okunekhono kokugcinwa kwedatha, okunikeza amandla onjiniyela ukuthi bangeze noma basuse isikhala njengoba kudingeka.
- Ukubuka imininingwane yendawo yetafula
KHETHA * KUSUKA dba_tablespaces;
- Ukwengeza idatha endaweni yetafula
ALTER TABLESPACE table_space_name ENGEZA IDATHAFILE 'datafile_path' SIZE usayizi;
Imitapo yolwazi kanye nemisebenzi ehilelekile ku-Table Space Operations
I-Oracle SQL inikeza ukubukwa kolwazi okumbalwa okunikeza idatha enemininingwane mayelana nokusetshenziswa kwesikhala sethebula kanye nezibalo. Lokhu kubuka kubandakanya i-DBA_TABLESPACES, USER_TABLESPACES, kanye ne-V_$TABLESPACE.
Ngaphezu kwalokho, imisebenzi efana ne-TO_TABLESPACE_NAME kanye ne-FROM_TABLESPACE_NAME inikeza izindlela ezingokoqobo zokuphatha ukusebenza kwesikhala sethebula. Le miyalo yenza kube lula imisebenzi ethile ngaphakathi kokuphathwa kwesikhala setafula, isb, ukuqamba kabusha izikhala zetafula, ukunwetshwa kosayizi nokunye.
Sengiphetha, ukuphatha isikhala setafula le-Oracle kuwumsebenzi odinga ukunakwa njalo. Onjiniyela kufanele baqinisekise ukuthi izindawo zamathebula zinesitoreji esanele futhi basebenzise amasu afanele ukuze zilawuleke kahle. Lokhu kuzosiza futhi ekusebenzeni kahle kwesizindalwazi, ngaleyo ndlela kuqinisekise ubuqotho bedatha futhi kuvinjwe amaphutha esistimu angenzeka. Emkhakheni omkhulu we-Oracle SQL, ukuqonda nokuphatha kahle isikhala setafula kuhlala kuyikhono eliyinhloko lonjiniyela. Ilokhu ivela futhi nokho ibalulekile.
