ORACLE 用户和表空间的相关操作

select * from USER_USERS

SELECT * FROM Dba_Data_Files ddf
--WHERE ddf.tablespace_name = 'TablespaceName';

select * from v$version;

create tablespace TABLESPACE_NAME 
datafile 'G:\TABLESPACE\TABLESPACE_NAME.DBF' 
size 1500M 
autoextend on next 5M maxsize 3000M;

--创建用户
create user USER_NAME identified by USER_PASSWORD;
--指定 表空间 和 临时表空间
default tablespace TABLESPACE_NAME 
temporary tablespace TEMP_TABLESPACE_NAME; 

GRANT
CONNECT,                
RESOURCE,               
DBA,                  
unlimited tablespace,
CREATE  SESSION,         
CREATE ANY SEQUENCE,     
CREATE ANY TABLE,        
CREATE ANY VIEW ,        
CREATE ANY INDEX,        
CREATE ANY PROCEDURE,    
CREATE ANY DIRECTORY,    
ALTER  SESSION, 
ALTER ANY SEQUENCE,     
ALTER ANY TABLE,        
--ALTER ANY VIEW ,        --不能修改视图
ALTER ANY INDEX,        
ALTER ANY PROCEDURE,    
--ALTER ANY DIRECTORY,    --不能修改目录
--DROP  SESSION,       --不能删除Session
DROP ANY SEQUENCE,     
DROP ANY TABLE,        
DROP ANY VIEW ,        
DROP ANY INDEX,        
DROP ANY PROCEDURE,    
DROP ANY DIRECTORY,    
SELECT ANY TABLE, 
SELECT ANY DICTIONARY,
INSERT ANY TABLE, 
UPDATE ANY TABLE, 
DELETE ANY TABLE,
DEBUG ANY PROCEDURE,
DEBUG CONNECT SESSION,
exp_full_database,  
imp_full_database     
TO USER_NAME;

exp USER_NAME/USER_PASSWPRD@127.0.0.1/ORCL file=D:\dmp\file.dmp

imp USER_NAME/USER_PASSWPRD@127.0.0.1/ORCL file=D:\dmp\file.dmp log=D:\dmp\file.log full=y