db.dobo.sk

rychlovka – datafiles

bez komentára

SQL> desc dba_data_files

SQL> select FILE_NAME, TABLESPACE_NAME from dba_data_files;

////////////////////////////////////////////////////////

volne miesto v datafiloch

SQL> desc dba_free_space

SQL> select TABLESPACE_NAME from dba_free_space;

////////////////////////////////////////////////////////

ako nadefinovat autoextend pre datafile

SQL> alter database datafile <path to datafile> autoextend on maxsize <size>M;

///////////////////////////////////////////////////////

datafile recovery

SQL> alter datafile <path to datafile> offline;

SQL> recover datafile <path to datafile>;

píše: ďobo

Jún 3rd, 2015 o 10:44 pm

chlievik: oracle

okomentuj