摘要： 阅读全文

摘要：DUAL is a table automatically created by Oracle Database along with the datadictionary. DUAL is in the schema of the user SYS but is accessible by t... 阅读全文

摘要：oracle空表处理：1.动态生成给空表分配segment的命令：SQL>Select 'alter table '||table_name||' allocate extent;' from user_tables where num_rows=0；2.在命令窗口右键‘标记’，复制生成的命令并执行... 阅读全文