摘要:
查询空表并导出修改空表语句select 'alter table '||table_name||' allocate extent;' from user_tables where num_rows=0 or num_rows is null;如果表存在分区alter table 表名 modify... 阅读全文
摘要:
>sqlplus /nolog>conn / as sysdbasql>shutdown immediatesql>startup mountsql>ALTER SYSTEM ENABLE RESTRICTED SESSION;sql>ALTER SYSTEM SET JOB_QUEUE_PROCE... 阅读全文