oracle 数据库创建表空间和用户级导入数据等的一些语句

表空间：

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;