oracle升级expdp备份建表等

oracle10G升级
sqlplus '/as sysdba'
SQL>startup upgrade;
SQL>spool patch.log;
SQL>@?/rdbms/admin/catupgrd.sql;
SQL>spool off;
SQL>shutdown immediate;
SQL>startup;
SQL>@?/rdbms/admin/utlrp.sql

oracle 9i升级
sqlplus '/as sysdba'
SQL>startup migrate;
SQL>spool patch.log;
SQL>@?/rdbms/admin/catpatch.sql;
SQL>spool off;
SQL>shutdown immediate;
SQL>startup;
SQL>@?/rdbms/admin/utlrp.sql

expdp and impdp 用法
mkdir dump

SQL>create directory dump as '/opt/oracle/dump';
SQL>grant read,write on directory dump to money;(money是指用户)


Create Table and Back Table

create table yh_user_tbl_bak as select * from yh_user_tbl;
drop table yh_user_tbl;
create table yh_user_tbl as select * from yh_user_tbl_bak;

Oracle 10G Close Recyclebin

alter session set recyclebin=off;
alter system set recyclebin=off;