This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
db:oracledb [2024/01/16 11:11] tomas [DATABAZE] |
db:oracledb [2024/01/16 11:14] tomas |
||
---|---|---|---|
Line 317: | Line 317: | ||
ALTER SYSTEM SET LOG_ARCHIVE_DEST_4=' | ALTER SYSTEM SET LOG_ARCHIVE_DEST_4=' | ||
- | %%ALTER SYSTEM SET LOG_ARCHIVE_DEST_$='' | + | %%ALTER SYSTEM SET LOG_ARCHIVE_DEST_$='' |
- | %% ... smazani parametru\\ | + | |
ALTER SYSTEM SET DB_BLOCK_CHECKSUM TRUE; ... dybamicky prepne prepinac\\ | ALTER SYSTEM SET DB_BLOCK_CHECKSUM TRUE; ... dybamicky prepne prepinac\\ | ||
SHOW PARAMETERS ... ukaze aktualni parametry\\ | SHOW PARAMETERS ... ukaze aktualni parametry\\ | ||
Line 416: | Line 415: | ||
alter tablespace tblspc TEMPORARY; ... zmeni tabulkovy prostor na docasny tabulkovy prostor\\ | alter tablespace tblspc TEMPORARY; ... zmeni tabulkovy prostor na docasny tabulkovy prostor\\ | ||
alter tablespace tblspc TABLESPACE GROUP tblgroup1; ... prida tabulkovy prostor do skupiny tabulkovych prostoru\\ | alter tablespace tblspc TABLESPACE GROUP tblgroup1; ... prida tabulkovy prostor do skupiny tabulkovych prostoru\\ | ||
- | alter tablespace tblspc TABLESPACE GROUP ''; | + | %%alter tablespace tblspc TABLESPACE GROUP '' |
alter tablespace tblspc RENAME TO users; ... prejmenuje tabulkovy prostor (COMPACTIBLE parametr musi byt >= 10\\ | alter tablespace tblspc RENAME TO users; ... prejmenuje tabulkovy prostor (COMPACTIBLE parametr musi byt >= 10\\ | ||
alter tablespace tblspc RENAME DATAFILE '/ | alter tablespace tblspc RENAME DATAFILE '/ | ||
Line 533: | Line 532: | ||
ALTER SYSTEM SET UNDO_RETENTION=2400; | ALTER SYSTEM SET UNDO_RETENTION=2400; | ||
ALTER SYSTEM SET UNDO_TABLESPACE=undotbs2; | ALTER SYSTEM SET UNDO_TABLESPACE=undotbs2; | ||
- | ALTER SYSTEM SET UNDO_TABLESPACE=''; | + | %%ALTER SYSTEM SET UNDO_TABLESPACE='' |
ALTER TABLESPACE undotbs2 RETENTION NOGUARANTEE; | ALTER TABLESPACE undotbs2 RETENTION NOGUARANTEE; | ||
CREATE UNDO TABLESPACE undotbs2 RETENTION GUARANTEE; vytvori Undo TS undotbs2, ktery garantuje undo proceduru pro datove operace. Pokud opearce nemuze jiz zapisovat do undo, tak se stornuje\\ | CREATE UNDO TABLESPACE undotbs2 RETENTION GUARANTEE; vytvori Undo TS undotbs2, ktery garantuje undo proceduru pro datove operace. Pokud opearce nemuze jiz zapisovat do undo, tak se stornuje\\ | ||
Line 599: | Line 598: | ||
===Tabulky - Table=== | ===Tabulky - Table=== | ||
+ | SELECT table_name FROM user_tables; | ||
CREATE TABLE test (name VARCHAR(20)); | CREATE TABLE test (name VARCHAR(20)); | ||
create table sales (invoice_no NUMBER, s_y INT NOT NULL, s_m INT NOT NULL, s_d INT NOT NULL) PARTITION BY RANGE (Ss_y, _m, s_d) (partition jan04 values less than (2004, 2, 1), partition feb04 values less than (2004, 3, 1)); ... vytvori tabulku, ktera je spojenim vice tabulek. Pouziva se napriklad ve skladisti (warehouse) dat\\ | create table sales (invoice_no NUMBER, s_y INT NOT NULL, s_m INT NOT NULL, s_d INT NOT NULL) PARTITION BY RANGE (Ss_y, _m, s_d) (partition jan04 values less than (2004, 2, 1), partition feb04 values less than (2004, 3, 1)); ... vytvori tabulku, ktera je spojenim vice tabulek. Pouziva se napriklad ve skladisti (warehouse) dat\\ |