Oracle不删除用户,导入数据

来源：互联网发布：俾斯麦模型淘宝编辑：程序博客网时间：2024/06/02 03:05

###不删除用户,导入数据dd (){sqlplus / as sysdba <<!    set echo off;    set feedback off;    set heading off;    set pagesize 0;    set termout off;    set trimout on;    set trimspool on;    set linesize 3000;    spool ./drop.sql ;select 'drop table '||owner||'.'||table_name||' purge;' from dba_tables where owner=upper('$1');select 'drop view '||owner||'.'||view_name||';' from dba_views where  owner=upper('$1');select 'drop procedure '||owner||'.'||OBJECT_NAME||';' from dba_procedures where  owner=upper('$1');spool offexit!grep -v sql drop.sql >d.sqlsqlplus / as sysdba<<!@d.sql;@d.sql;exit!} chk (){sqlplus / as sysdba <<!    set echo off;    set feedback off;    set heading off;    set pagesize 0;    set termout off;    set trimout on;    set trimspool on;    set linesize 3000;spool chk.txt;select count(*) from dba_objects where owner=upper('$1');spool offexit!var=`grep -v -i sql chk.txt`if [ $var -ne 0 ]  then  echo "$1的对象未删除!" exitfi}if [ $#  -ne 1 ]  then  echo "请输入删除的用户名!"elsedd $1chk $1imp $1/$1 file=$1.dmp fromuser=$1fi

0 0