在sqlplus里打开本地SQL脚本,无法创建在当前用户下,急救~~~~ 你的.sql文件里可能有重联数据库的语句如:conn XXX/YYY@ZZZ.... 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 还有若你编辑过.sql文件,别忘了在执行前存盘.... 执行了比如用abc/abc登录执行后,显示执行完毕,可是结果却不是在ABC下,而是在SYS里 好急啊。。 /*==============================================================*//* Database name: ZZLK Database *//* DBMS name: ORACLE Version 9i *//* Created on: 2004-6-3 12:02:08 *//*==============================================================*/drop index TB_XX_INDEX/drop index ID_REPLY_INDEX/drop sequence SEXXID/drop trigger TM_XXFB_RIGGER/drop sequence SE_MID/drop sequence SE_RE_MID/drop trigger TB_MESSAGE_RIGGER/drop trigger TB_RE_MESSAGE_RIGGER/drop table TB_MESSAGE cascade constraints/drop table TB_MESSAGE_reply cascade constraints/drop table TB_XX cascade constraints/drop table TS_GX3 cascade constraints/drop table TS_GX2 cascade constraints/drop table TS_GX1 cascade constraints/drop table TS_BMD_ZSXX cascade constraints/drop table TS_BMD_XX cascade constraints/drop table TS_BMD_XWLB cascade constraints/drop table TS_BMD_BJFS cascade constraints/drop table TM_XXFB cascade constraints/drop table TM_DOWNLOAD_LOG cascade constraints/drop table TM_STU_LOG cascade constraints/drop table TM_INI cascade constraints/drop table TM_GL cascade constraints/drop table TD_ZZMM cascade constraints/drop table TD_ZYLY cascade constraints/drop table TD_XZQH cascade constraints/drop table TD_JGXZQH cascade constraints/drop table TD_ZJLX cascade constraints/drop table TD_YXDM cascade constraints/drop table TD_YSYZ cascade constraints/drop table TD_XZZW cascade constraints/drop table TD_SSZSXX cascade constraints/drop table TD_SSXWLB cascade constraints/drop table TD_SSDM cascade constraints/drop table TD_XSXWLB cascade constraints/drop table TD_QTXWLB cascade constraints/drop table TD_MZDM cascade constraints/drop table TD_MMWT cascade constraints/drop table TD_KSLY cascade constraints/drop table TD_JSZC cascade constraints/drop table TD_GZDWXZ cascade constraints/drop table TD_KSKM cascade constraints/drop table TB_SFYZ cascade constraints/drop table TM_LXFS cascade constraints/drop index TB_ZKZ_INDEX/drop table TB_ZKZ cascade constraints/drop table TM_UPLOAD_LOG cascade constraints/drop table TM_UPLOAD_INI cascade constraints/drop view v_ssxwlb/drop view v_sszsxx/drop view v_kcmc/drop view v_bmd//*==============================================================*//* Table: TB_SFYZ 身份验证 *//*==============================================================*/create table TB_SFYZ( XM varchar2(30) not null, BMBH CHAR(10) not null, PASSWORD VARCHAR2(30) not null, WTBH CHAR(2) not null, WTHD VARCHAR2(50), ZJLX varchar2(10) not null, ZJHM varchar2(40) not null)//*==============================================================*//* Table: TD_GZDWXZ 工作单位性质类别代码表 *//*==============================================================*/create table TD_GZDWXZ ( GZDWXZDM CHAR(2) not null, GZDWXZMC VARCHAR2(30) not null, constraint TD_GZDWXZ_PRIMARY primary key (GZDWXZDM))//*==============================================================*//* Table: TD_JSZC 技术职称代码表 *//*==============================================================*/create table TD_JSZC ( JSZCDM CHAR(1) not null, JSZCMC VARCHAR2(10), constraint TD_JSZC_PRIMARY primary key (JSZCDM))//*==============================================================*//* Table: TD_KSLY 考生来源代码表 *//*==============================================================*/create table TD_KSLY ( KSLYDM CHAR(1) not null, KSLYMC VARCHAR2(20), constraint TD_KSLY_PRIMARY primary key (KSLYDM))//*==============================================================*//* Table: TD_XZQH 行政区划代码表 *//*==============================================================*/create table TD_XZQH ( XZQHDM CHAR(6) not null, XZQHMC VARCHAR2(70), SSMC VARCHAR2(16), constraint TD_XZQH_PRIMARY primary key (XZQHDM))//*==============================================================*//* Table: TD_JGXZQH 籍贯行政区划代码表 *//*==============================================================*/create table TD_JGXZQH ( JGXZQHDM CHAR(6) not null, JGXZQHMC VARCHAR2(70), SSMC VARCHAR2(16), constraint TD_JGXZQH_PRIMARY primary key (JGXZQHDM))//*==============================================================*//* Table: TD_MMWT 密码问题表 *//*==============================================================*/create table TD_MMWT ( WTBH CHAR(2) not null, WTMC VARCHAR2(50) not null, constraint TD_MMWT_PRIMARY primary key (WTBH))//*==============================================================*//* Table: TD_MZDM 考生民族代码表 *//*==============================================================*/create table TD_MZDM ( MZDM CHAR(2) not null, MZMC VARCHAR2(20), constraint TD_MZDM_PRIMARY primary key (MZDM))//*==============================================================*//* Table: TD_XSXWLB 学士学位类别代码表 *//*==============================================================*/create table TD_XSXWLB ( XSXWLBDM CHAR(2) not null, XSXWLBMC VARCHAR2(30) not null, constraint TD_XSXWLB_PRIMARY primary key (XSXWLBDM))// 看一下那个sql文件,里面是否有connect system/manager类似的语句去掉即可。 是不是你用abc/abc as sysdba登录并执行的?如果是,那当前模式就是“SYS”了,所以就建到SYS里了!!!! 楼上的有道理!如果是 操作系统认证即使你没有这个用户也可以abc/abc as sysdba登陆conn / as sysdba也可以 我认为,如果执行成功,而你的脚本没有问题的话,不可能在abc用户下没有这些表,你再看看。如果是sys用户下有这些表,估计是你以前用sys用户连接后执行过这个脚本创建的。 我是ORCLE9I,登录的时候,提示输入用户名和密码的时候输的abc/abc执行显示成功。可是就是在ABC下找不到东西试了N次了。代码没有贴完。我最后,在每个表和视图前加了个abc.才成功创建了,可是有些不方便加地方就出问题了。 再借个地方问一下如何完全的删除abc这个用户或者删除一个数据库是 数据库管理面板里而不是用语句:) select * from all_users;有这个abc用户? 有尼。肯定有这个用户。abc 有connect restore 2个权限。:( oracle 统计数据 请问ORACLE中,system,sys,root,sysdba,这4种用户的默认密码是什么,如果忘记了如何找到他们,我现在就忘记了,可我都不知道怎么找到。谢 细粒度访问原则 这个简单的事务该怎样写 在表上创建trigger时提示权限不足该怎么解决。[在线等] 10.2 创建用户和以前的不一样了? 怎样让数据库表中的一列自动增加? 为什么我用dbms_job.submit定时调用一个存储过程到了时间不执行? 如何提高Oracle数据库的检索速度? 关于在VISIO中绘制数据库模型图的几点疑问? 查数据库中所有表的名称 execute immediate 的问题.
/* Database name: ZZLK Database */
/* DBMS name: ORACLE Version 9i */
/* Created on: 2004-6-3 12:02:08 */
/*==============================================================*/
drop index TB_XX_INDEX
/drop index ID_REPLY_INDEX
/drop sequence SEXXID
/
drop trigger TM_XXFB_RIGGER
/drop sequence SE_MID
/drop sequence SE_RE_MID
/drop trigger TB_MESSAGE_RIGGER
/drop trigger TB_RE_MESSAGE_RIGGER
/
drop table TB_MESSAGE cascade constraints
/drop table TB_MESSAGE_reply cascade constraints
/
drop table TB_XX cascade constraints
/
drop table TS_GX3 cascade constraints
/
drop table TS_GX2 cascade constraints
/
drop table TS_GX1 cascade constraints
/
drop table TS_BMD_ZSXX cascade constraints
/
drop table TS_BMD_XX cascade constraints
/
drop table TS_BMD_XWLB cascade constraints
/
drop table TS_BMD_BJFS cascade constraints
/
drop table TM_XXFB cascade constraints
/drop table TM_DOWNLOAD_LOG cascade constraints
/drop table TM_STU_LOG cascade constraints
/
drop table TM_INI cascade constraints
/
drop table TM_GL cascade constraints
/
drop table TD_ZZMM cascade constraints
/
drop table TD_ZYLY cascade constraints
/drop table TD_XZQH cascade constraints
/drop table TD_JGXZQH cascade constraints
/drop table TD_ZJLX cascade constraints
/
drop table TD_YXDM cascade constraints
/
drop table TD_YSYZ cascade constraints
/
drop table TD_XZZW cascade constraints
/
drop table TD_SSZSXX cascade constraints
/
drop table TD_SSXWLB cascade constraints
/
drop table TD_SSDM cascade constraints
/drop table TD_XSXWLB cascade constraints
/drop table TD_QTXWLB cascade constraints
/
drop table TD_MZDM cascade constraints
/
drop table TD_MMWT cascade constraints
/
drop table TD_KSLY cascade constraints
/
drop table TD_JSZC cascade constraints
/
drop table TD_GZDWXZ cascade constraints
/drop table TD_KSKM cascade constraints
/
drop table TB_SFYZ cascade constraints
/drop table TM_LXFS cascade constraints
/drop index TB_ZKZ_INDEX
/drop table TB_ZKZ cascade constraints
/drop table TM_UPLOAD_LOG cascade constraints
/drop table TM_UPLOAD_INI cascade constraints
/drop view v_ssxwlb
/drop view v_sszsxx
/drop view v_kcmc
/drop view v_bmd
//*==============================================================*/
/* Table: TB_SFYZ 身份验证 */
/*==============================================================*/create table TB_SFYZ
(
XM varchar2(30) not null,
BMBH CHAR(10) not null,
PASSWORD VARCHAR2(30) not null,
WTBH CHAR(2) not null,
WTHD VARCHAR2(50),
ZJLX varchar2(10) not null,
ZJHM varchar2(40) not null
)
/
/*==============================================================*/
/* Table: TD_GZDWXZ 工作单位性质类别代码表 */
/*==============================================================*/
create table TD_GZDWXZ (
GZDWXZDM CHAR(2) not null,
GZDWXZMC VARCHAR2(30) not null,
constraint TD_GZDWXZ_PRIMARY primary key (GZDWXZDM)
)
/
/*==============================================================*/
/* Table: TD_JSZC 技术职称代码表 */
/*==============================================================*/
create table TD_JSZC (
JSZCDM CHAR(1) not null,
JSZCMC VARCHAR2(10),
constraint TD_JSZC_PRIMARY primary key (JSZCDM)
)
/
/*==============================================================*/
/* Table: TD_KSLY 考生来源代码表 */
/*==============================================================*/
create table TD_KSLY (
KSLYDM CHAR(1) not null,
KSLYMC VARCHAR2(20),
constraint TD_KSLY_PRIMARY primary key (KSLYDM)
)
//*==============================================================*/
/* Table: TD_XZQH 行政区划代码表 */
/*==============================================================*/create table TD_XZQH (
XZQHDM CHAR(6) not null,
XZQHMC VARCHAR2(70),
SSMC VARCHAR2(16),
constraint TD_XZQH_PRIMARY primary key (XZQHDM)
)
//*==============================================================*/
/* Table: TD_JGXZQH 籍贯行政区划代码表 */
/*==============================================================*/create table TD_JGXZQH (
JGXZQHDM CHAR(6) not null,
JGXZQHMC VARCHAR2(70),
SSMC VARCHAR2(16),
constraint TD_JGXZQH_PRIMARY primary key (JGXZQHDM)
)
//*==============================================================*/
/* Table: TD_MMWT 密码问题表 */
/*==============================================================*/
create table TD_MMWT (
WTBH CHAR(2) not null,
WTMC VARCHAR2(50) not null,
constraint TD_MMWT_PRIMARY primary key (WTBH)
)
/
/*==============================================================*/
/* Table: TD_MZDM 考生民族代码表 */
/*==============================================================*/
create table TD_MZDM (
MZDM CHAR(2) not null,
MZMC VARCHAR2(20),
constraint TD_MZDM_PRIMARY primary key (MZDM)
)
//*==============================================================*/
/* Table: TD_XSXWLB 学士学位类别代码表 */
/*==============================================================*/create table TD_XSXWLB (
XSXWLBDM CHAR(2) not null,
XSXWLBMC VARCHAR2(30) not null,
constraint TD_XSXWLB_PRIMARY primary key (XSXWLBDM)
)
//
里面是否有
connect system/manager类似的语句
去掉即可。
即使你没有这个用户也可以abc/abc as sysdba登陆
conn / as sysdba也可以
执行显示成功。可是就是在ABC下找不到东西试了N次了。
代码没有贴完。我最后,在每个表和视图前加了个abc.
才成功创建了,可是有些不方便加地方就出问题了。
是 数据库管理面板里
而不是用语句:)
有这个abc用户?
abc 有connect restore 2个权限。:(