oracle备份

--//创建数据表空间
create tablespace tipoatest_data    
logging    
datafile 'G:\app\tepper\oradata\orcl\tipoatest_data.DBF'    
size 32m    
autoextend on    
next 32m maxsize 2048m    
extent management local;  
--//创建临时表空间 
create temporary tablespace tipoatest_temp    
tempfile 'G:\app\tepper\oradata\orcl\tipoatest_temp.DBF'    
size 32m    
autoextend on    
next 32m maxsize 2048m    
extent management local; 
--创建用户并指定表空间
create user g4studio identified by g4studio    
default tablespace wsbs_data    
temporary tablespace wsbs_temp;  
--给用户授予权限 
Grant dba to tipoa; 
Grant connect to tipoa
---给用户指定表空间
alter user tipoa default tablespace tipoatest_data
alter user tipoa temporary tablespace tipoatest_temp