表空间:
CREATE TABLESPACE youngtop
LOGGING
DATAFILE 'D:\oracle\product\10.2.0\oradata\yspt\youngtop.DBF' SIZE 5M
AUTOEXTEND
ON NEXT 640K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO ;
用户:bmys2010
CREATE USER bmys2010 PROFILE DEFAULT
IDENTIFIED BY "a" DEFAULT TABLESPACE efmcs
TEMPORARY TABLESPACE TEMP
ACCOUNT UNLOCK;
GRANT CONNECT TO bmys2010;
GRANT RESOURCE TO bmys2010;
GRANT CREATE ANY TABLE TO bmys2010;
grant select any table to bmys2010;
grant dba to bmus2010
导入数据
imp username/password@SID file=导出位置 log=导出位置 full=y;
imp system/system123@192.168.1.3/orcl file=e:test.dmp full=y ignore=y;
imp system/system123@192.168.1.3/orcl file==Z:\dm\cms.dmp touser=zcms fromuser=CMS
导出数据
exp system/system123@192.168.1.3/orcl file=e:test.dmp full=y ignore=y;
更改用户密码
alter user system identified by sys
解锁
alter user system account unlock;
删除用户
drop user zcms cascade
删除表空间
drop tablespace tablespacename including contents and datafiles cascade constraints;
CREATE TABLESPACE youngtop
LOGGING
DATAFILE 'D:\oracle\product\10.2.0\oradata\yspt\youngtop.DBF' SIZE 5M
AUTOEXTEND
ON NEXT 640K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO ;
用户:bmys2010
CREATE USER bmys2010 PROFILE DEFAULT
IDENTIFIED BY "a" DEFAULT TABLESPACE efmcs
TEMPORARY TABLESPACE TEMP
ACCOUNT UNLOCK;
GRANT CONNECT TO bmys2010;
GRANT RESOURCE TO bmys2010;
GRANT CREATE ANY TABLE TO bmys2010;
grant select any table to bmys2010;
grant dba to bmus2010
导入数据
imp username/password@SID file=导出位置 log=导出位置 full=y;
imp system/system123@192.168.1.3/orcl file=e:test.dmp full=y ignore=y;
imp system/system123@192.168.1.3/orcl file==Z:\dm\cms.dmp touser=zcms fromuser=CMS
导出数据
exp system/system123@192.168.1.3/orcl file=e:test.dmp full=y ignore=y;
更改用户密码
alter user system identified by sys
解锁
alter user system account unlock;
删除用户
drop user zcms cascade
删除表空间
drop tablespace tablespacename including contents and datafiles cascade constraints;