oracle creat tablespace unlock user and so on

 

creat tablespace

 

create user szhdw identified by szhdw123456 default tablespace dpn;
grant DBA to szhdw with admin option;
grant DBA to szhdw with admin option;
grant ALTER ANY CLUSTER to szhdw with admin option;
grant ALTER ANY DIMENSION to szhdw with admin option;
grant ALTER ANY INDEX to szhdw with admin option;
grant ALTER ANY INDEXTYPE to szhdw with admin option;
grant ALTER ANY LIBRARY to szhdw with admin option;
grant ALTER ANY OUTLINE to szhdw with admin option;
grant ALTER ANY PROCEDURE to szhdw with admin option;
grant ALTER ANY ROLE to szhdw with admin option;
grant ALTER ANY SEQUENCE to szhdw with admin option;
grant ALTER ANY SNAPSHOT to szhdw with admin option;
grant ALTER ANY TABLE to szhdw with admin option;
grant ALTER ANY TRIGGER to szhdw with admin option;
grant ALTER ANY TYPE to szhdw with admin option;
grant ALTER DATABASE to szhdw with admin option;
grant ALTER PROFILE to szhdw with admin option;
grant ALTER RESOURCE COST to szhdw with admin option;
grant ALTER ROLLBACK SEGMENT to szhdw with admin option;
grant ALTER SESSION to szhdw with admin option;
grant ALTER SYSTEM to szhdw with admin option;
grant ALTER TABLESPACE to szhdw with admin option;
grant ALTER USER to szhdw with admin option;
grant ANALYZE ANY to szhdw with admin option;
grant AUDIT ANY to szhdw with admin option;
grant AUDIT SYSTEM to szhdw with admin option;
grant BACKUP ANY TABLE to szhdw with admin option;
grant BECOME USER to szhdw with admin option;
grant COMMENT ANY TABLE to szhdw with admin option;
grant CREATE ANY CLUSTER to szhdw with admin option;
grant CREATE ANY CONTEXT to szhdw with admin option;
grant CREATE ANY DIMENSION to szhdw with admin option;
grant CREATE ANY DIRECTORY to szhdw with admin option;
grant CREATE ANY INDEX to szhdw with admin option;
grant CREATE ANY INDEXTYPE to szhdw with admin option;
grant CREATE ANY LIBRARY to szhdw with admin option;
grant CREATE ANY OUTLINE to szhdw with admin option;
grant CREATE ANY PROCEDURE to szhdw with admin option;
grant CREATE ANY SEQUENCE to szhdw with admin option;
grant CREATE ANY SNAPSHOT to szhdw with admin option;
grant CREATE ANY SYNONYM to szhdw with admin option;
grant CREATE ANY TABLE to szhdw with admin option;
grant CREATE ANY TRIGGER to szhdw with admin option;
grant CREATE ANY TYPE to szhdw with admin option;
grant CREATE ANY VIEW to szhdw with admin option;
grant CREATE CLUSTER to szhdw with admin option;
grant CREATE DATABASE LINK to szhdw with admin option;
grant CREATE DIMENSION to szhdw with admin option;
grant CREATE INDEXTYPE to szhdw with admin option;
grant CREATE LIBRARY to szhdw with admin option;
grant CREATE PROCEDURE to szhdw with admin option;
grant CREATE PROFILE to szhdw with admin option;
grant CREATE PUBLIC DATABASE LINK to szhdw with admin option;
grant CREATE PUBLIC SYNONYM to szhdw with admin option;
grant CREATE ROLE to szhdw with admin option;
grant CREATE ROLLBACK SEGMENT to szhdw with admin option;
grant CREATE SEQUENCE to szhdw with admin option;
grant CREATE SESSION to szhdw with admin option;
grant CREATE SNAPSHOT to szhdw with admin option;
grant CREATE SYNONYM to szhdw with admin option;
grant CREATE TABLE to szhdw with admin option;
grant CREATE TABLESPACE to szhdw with admin option;
grant CREATE TRIGGER to szhdw with admin option;
grant CREATE TYPE to szhdw with admin option;
grant CREATE USER to szhdw with admin option;
grant CREATE VIEW to szhdw with admin option;
grant DEBUG ANY PROCEDURE to szhdw with admin option;
grant DEBUG CONNECT SESSION to szhdw with admin option;
grant DELETE ANY TABLE to szhdw with admin option;
grant DROP ANY CLUSTER to szhdw with admin option;
grant DROP ANY CONTEXT to szhdw with admin option;
grant DROP ANY DIMENSION to szhdw with admin option;
grant DROP ANY DIRECTORY to szhdw with admin option;
grant DROP ANY INDEXTYPE to szhdw with admin option;
grant DROP ANY LIBRARY to szhdw with admin option;
grant DROP ANY OUTLINE to szhdw with admin option;
grant DROP ANY PROCEDURE to szhdw with admin option;
grant DROP ANY ROLE to szhdw with admin option;
grant DROP ANY SEQUENCE to szhdw with admin option;
grant DROP ANY SNAPSHOT to szhdw with admin option;
grant DROP ANY SYNONYM to szhdw with admin option;
grant DROP ANY TABLE to szhdw with admin option;
grant DROP ANY TRIGGER to szhdw with admin option;
grant DROP ANY TYPE to szhdw with admin option;
grant DROP ANY VIEW to szhdw with admin option;
grant DROP PROFILE to szhdw with admin option;
grant DROP PUBLIC DATABASE LINK to szhdw with admin option;
grant DROP PUBLIC SYNONYM to szhdw with admin option;
grant DROP ROLLBACK SEGMENT to szhdw with admin option;
grant DROP TABLESPACE to szhdw with admin option;
grant DROP USER to szhdw with admin option;
grant EXECUTE ANY INDEXTYPE to szhdw with admin option;
grant EXECUTE ANY LIBRARY to szhdw with admin option;
grant EXECUTE ANY PROCEDURE to szhdw with admin option;
grant EXECUTE ANY TYPE to szhdw with admin option;
grant FORCE ANY TRANSACTION to szhdw with admin option;
grant FORCE TRANSACTION to szhdw with admin option;
grant GLOBAL QUERY REWRITE to szhdw with admin option;
grant grant ANY OBJECT PRIVILEGE to szhdw with admin option;
grant grant ANY PRIVILEGE to szhdw with admin option;
grant grant ANY ROLE to szhdw with admin option;
grant INSERT ANY TABLE to szhdw with admin option;
grant LOCK ANY TABLE to szhdw with admin option;
grant MANAGE TABLESPACE to szhdw with admin option;
grant ON COMMIT REFRESH to szhdw with admin option;
grant QUERY REWRITE to szhdw with admin option;
grant RESTRICTED SESSION to szhdw with admin option;
grant SELECT ANY DICTIONARY to szhdw with admin option;
grant SELECT ANY SEQUENCE to szhdw with admin option;
grant SELECT ANY TABLE to szhdw with admin option;
grant UNDER ANY TABLE to szhdw with admin option;
grant UNDER ANY TYPE to szhdw with admin option;
grant UNDER ANY VIEW to szhdw with admin option;
grant UNLIMITED TABLESPACE to szhdw with admin option;
grant UPDATE ANY TABLE to szhdw with admin option;

exp szhdw/szhdw123456@orcl file=d:\数据库备份\oracle\dpn_20100123.dmp

imp szhdw/szhdw123456@orcl file=d:\数据库备份\oracle\dpn_20100123.dmp full=y