比较方便的就是drop user然后重建导入.否则
select 'drop table '||tablename from user_tables
再执行生成的sql.drop掉所有表.
select 'drop table '||tablename from user_tables
再执行生成的sql.drop掉所有表.
解决方案 »
- 问个ubuntu下安装oracle11g问题
- 大家有谁做过,oralce数据的增量导入与导出。
- 比较为什么会有重复行呢
- 求ORACLE数据库的备份与恢复方法或命令,来着有分!!!
- 我是专学PL/SQL编程的,但是我觉得这个不像是真正意义的编程! 大家进来看看吧!
- 如何执行字段中的sql语句?
- 安装后开始菜单oradb10g_home1里没有Enterprise Manager Console是什么原因?
- ORA-01445: 无法从没有键值保存表的连接视图中选择 ROWID ORA-02063: 紧接着line(源于DB_LINK)
- 如何学习oracle
- 呀呼!! google又能上啦! 散点分啦
- DATABASE LINK问题
- 请教:c /false/'false'/是什么意思?谢谢
conn aaa/aaa@gg
drop table tablename
exit
imp ..........................
把用户下的表清空就用DROP USER,如果是清空你建的数据库里的所以表就用工具直接卸载库。
新建USER如下:
CREATE USER <user_name>
identified by "<password>"
但是光建了还不行,还要授权的.GRANT <权限列表> to <user_name>;
我一般先授系统权限再授对象权限.
我刚开始接触ORACLE,如果有说错的地方还请大家批评,指正
identified by "<password>" GRANT <权限列表> to <user_name>;
/
commit;
/
CREATE USER pms2user IDENTIFIED BY pms2user ;
/
commit;
/
GRANT CONNECT, RESOURCE, CREATE VIEW, CREATE PUBLIC SYNONYM TO pms2user WITH ADMIN OPTION;
/
commit;
/
GRANT ALTER ANY ROLE, ALTER ANY SEQUENCE, ALTER ANY TABLE, ALTER TABLESPACE,
ALTER ANY TRIGGER, COMMENT ANY TABLE, CREATE ANY SEQUENCE, CREATE ANY TABLE,
CREATE ANY TRIGGER, CREATE ROLE, CREATE TABLESPACE, CREATE USER, DROP ANY
SEQUENCE, DROP ANY TABLE, DROP ANY TRIGGER, DROP TABLESPACE, DROP USER, DROP
ANY ROLE, GRANT ANY ROLE, INSERT ANY TABLE, SELECT ANY TABLE, UPDATE ANY
TABLE TO pms2user;
/
commit;/
CONNECT pms2user/pms2user@Symber;CREATE TABLE Pms2User."User"(USERID NUMBER (10,0) NOT NULL,ROLEID NUMBER (10,0)
NOT NULL,NAME VARCHAR2 (200) NOT NULL,PASSWORD VARCHAR2 (200) NOT NULL,GENDER
NUMBER (10,0) NOT NULL,REGTIME DATE NOT NULL,STATUS NUMBER (10,0) NOT
NULL,REALNAME VARCHAR2 (200) ,QUESTION VARCHAR2 (200) ,ANSWER VARCHAR2
(200) ,DEPT VARCHAR2 (200) ,DUTY VARCHAR2 (200) ,TELEPHONE VARCHAR2
(200) ,ADDRESS VARCHAR2 (200) ,EMAIL VARCHAR2 (200) ,WORKCONTENT VARCHAR2
(500) ,ISINNER NUMBER (1,0) NOT NULL,CONSTRAINT PK__USER PRIMARY KEY ( UserId ) ) organization index ;/CREATE TABLE Pms2User.ALERTTEMP(HISTORYALERTTEMPID NUMBER (10,0) NOT NULL,ALERTTEMPID
NUMBER (10,0) NOT NULL,NAME VARCHAR2 (200) NOT NULL,DESCRIPTION VARCHAR2
(500) ,ALERTTYPE NUMBER (10,0) NOT NULL,CREATETIME DATE NOT NULL,VALUEA1
float(53) ,VALUEA2 float(53) ,VALUEB1 float(53) ,VALUEB2 float(53)
,VALUEC1 float(53) ,VALUEC2 float(53) ,VALUED1 float(53) ,VALUED2
float(53) ,STATUS NUMBER (10,0) NOT NULL,CONSTRAINT PK__ALERTTEMP PRIMARY KEY ( HistoryAlertTempId ) ) organization index ;/
obj_type varchar2(100);
v_SQL varchar2(200);
cursor uob is SELECT OBJECT_NAME,OBJECT_TYPE FROM user_objects;
begin
open uob;
LOOP
EXIT WHEN uob%NOTFOUND;
FETCH uob INTO obj_name,obj_type;
v_SQL := 'drop ' || obj_type ' ' || obj_name;
EXECUTE IMMEDIATE v_SQL;exception
when others then
null;
end;