http://iotn.co.kr ¿¬¶ôó: gilho.kr@gmail.com [ The Japanese government should apologize to Japanese Military Sexual Slavery victim. / ìíÜâïÙݤªÏìíÜâÏÚªÎàõîÜÒ¿ÖË?ßåíºªËÞóñªª¹ªÙª. ]
shut immediate
startup
@?/rdbms/admin/catbundle.sql cpu apply
alter system set sga_max_size=20g scope=spfile;
alter system set sga_target=0 scope=spfile;
alter system set audit_trail='NONE' scope=spfile;
alter system set log_archive_format='%t_%s_%r.arc' scope=spfile;
alter system set log_archive_dest_1='location=/oracle/arch/';
create directory expdp as '/oracle/backup';
alter system set streams_pool_size=200m;
drop public synonym OlapFactView;
drop public synonym OlapDimView;
drop public synonym DBMS_ODM;
delete from sys.exppkgact$ where package = 'DBMS_AW_EXP' and schema= 'SYS';
commit;