--创建表空间
create TABLESPACE FUWUBAO_TBS datafile 'C:\oracle\oradata\orcldb\FUWUBAO_TBS.DBF' size 256M autoextend on next 16M MAXSIZE 256M EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONLINE PERMANENT SEGMENT SPACE MANAGEMENT AUTO;
--创建临时表空间(临时缓存,加快运行速度)
CREATE TEMPORARY TABLESPACE SPECIMEN_TEMP_TBS tempfile 'C:\oracle\oradata\orcldb\FUWUBAO_TEMP_TBS.DBF' SIZE 16M REUSE AUTOEXTEND ON NEXT 16M MAXSIZE 128M EXTENT MANAGEMENT LOCAL;
--创建用户
create user fuwubao identified by fuwubao default tablespace FUWUBAO_TBS temporary tablespace FUWUBAO_TEMP_TBS profile DEFAULT;
其中:user后接用户名,identified by 后面接密码;
在创建用户时,将表空间FUWUBAO_TBS和临时表空间FUWUBAO_TEMP_TBS联系起来。
--给用户赋权
GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW ,DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,DBA,CONNECT,RESOURCE,CREATE SESSION TO ban
--删除表空间
drop tablespace zfmi including contents and datafiles cascade constraints;
导入数据库的操作:
cmd中:
定位到oracle\product\10.2.0\db_1\BIN
imp fuwubao/fuwubao@orcl fromuser=fuwubao touser=fuwubao file=C:\fuwubao.dmp
其中:fuwubao/fuwubao@orcl 为: username/password
fromuser 为导出数据库的用户;
touser为导入表空间所属的用户;
--数据库导出
exp fuwubao/fuwubao@orcldb file=D:\fuwubao.dmp