表空间的定义:
CREATE TABLESPACE tablespace_Name
DATAFILE '/DESK3/ORADATA/DB01/APP_DATA01.DBF' SIZE 200M
把以前的表从system表空间下转移到新的表空间下:Use "EXPORT/IMPORT" tools,
CREATE TABLESPACE tablespace_Name
DATAFILE '/DESK3/ORADATA/DB01/APP_DATA01.DBF' SIZE 200M
把以前的表从system表空间下转移到新的表空间下:Use "EXPORT/IMPORT" tools,
DATAFILE datafile_clause]
[, datafile_clause]...
[MINIMUM EXTENT integer[K|M]]
[LOGGING|NOLOGGING]
[DEFAULT storage_clause ]
[ONLINE|OFFLINE]
[PERMANENT|TEMPORARY]
[extent_management_clause]
一个用户,授权,然后为用户指定表空间,用创建的用户登陆建立的表就不在System表空间上了。
(only nonpartitioned table)
2.recreate the indexes
CREATE TABLESPACE "DCSDBA"
LOGGING
DATAFILE 'D:\ORACLE\ORADATA\DCSDBA\DCSDBA.ora' SIZE 100M REUSE
AUTOEXTEND
ON NEXT 100M MAXSIZE unlimited DEFAULT
STORAGE ( INITIAL 10K NEXT 10K MINEXTENTS 1 MAXEXTENTS UNLIMITED
PCTINCREASE 50 ) ;
/***创建用户****/
Create user 用户名 identified by 密码 default tablespace 表空间名 quota unlimited on 表空间名 temporary tablespace temp quota unlimited on temp ;错误的:Create user username identified by possword default tablespace b2bdbts quota unlimited on b2bdbts temporary tablespace temp quota unlimited on temp ;Create user root identified by p321 default tablespace "b2bdbts" quota unlimited on "b2bdbts" temporary tablespace temp quota unlimited on temp ;
/****授权****/
GRANT CONNECT,resource TO dcsall ; 授权这句话就可以了
grant connect,resource to 用户名