-
编辑 删除
dbms_stats
exec dbms_stats.gather_table_stats('SCOTT','T1');exec dbms_stats.gather_table_stats('SCOTT','T1',stattab=>'STATIC_TABLE');exec dbms_stats.gather_index_stats('SCOTT','IDX_T1');exec dbms_stats.g...
-
编辑 删除
dbms_redefinition
exec dbms_redefinition.can_redef_table('scott','t1',dbms_redefinition.CONS_USE_ROWID);exec dbms_redefinition.can_redef_table('scott','t1',dbms_redefinition.CONS_USE_PK);CREATE TABLE scott.t1_p...
-
编辑 删除
dbms_file_transfer
BEGINDBMS_FILE_TRANSFER.COPY_FILE(source_directory_object => 'DUMPDIR1',source_file_name => 'tbs_tran01.dmp',destination_directory_object => 'END_DIR',destination_file_name => 'tbs_tran01_des....
-
编辑 删除
dbms_job
DECLARE X NUMBER;BEGIN SYS.DBMS_JOB.SUBMIT ( job => X ,what &...
-
编辑 删除
utl_file
create directory utl_path as '/home/oracle/';grant read,write on directory utl_path to scott;grant execute on utl_file to scott;conn scott/tigerdeclarev_hand_file utl_file.file_type;cursor cur...
-
编辑 删除
DBMS_ERRLOG
CREATE TABLE T1 AS SELECT ROWNUM A,ROWNUM B FROM DBA_SEGMENTS WHERE ROWNUM <=10;CREATE TABLE T2 AS SELECT ROWNUM A,ROWNUM B FROM DBA_SEGMENTS WHERE ROWNUM <=20;ALTER TABLE T1 ADD CONSTRAIN...
