sysでログイン！
alter system set sga_max_size=1536M;
alter system set sga_target=1536M;
alter system set pga_aggregate_target=512M;
port確認
select dbms_xdb.gethttpport(), dbms_xdb.getftpport() from dual;
port変更
begin dbms_xdb.sethttpport('18080');end;/
conn sys/sys as SYSDBA
ALTER SYSTEM FLUSH SHARED_POOL;
ALTER SYSTEM FLUSH BUFFER_CACHE;
begin
declare
CURSOR IND_CURR IS
SELECT INDEX_NAME
FROM user_indexes
where status='UNUSABLE';
SQL_VAL varchar2(300);
DATA_VAL varchar2(300);
begin
FOR currVal IN IND_CURR LOOP
DATA_VAL := currVal.INDEX_NAME;
SQL_VAL := 'alter index ' || DATA_VAL || ' rebuild';
execute immediate SQL_VAL;
END LOOP;
end;
end;
/
set long 2000
set heading off
set line 120
set pages 2000
set long 2000
set heading off
set trimspool off
set feedback off
set longchunksize 600
EXEC DBMS_METADATA.SET_TRANSFORM_PARAM(
DBMS_METADATA.SESSION_TRANSFORM,'SQLTERMINATOR',TRUE)
spool create_table.sql
select
- dbms_metadata.get_ddl('TABLE',table_name)
dbms_metadata.get_ddl('TABLE',table_name)
from user_tables;
spool off;
最終更新：2009年09月29日 17:09
