CREATE TABLESPACE student DATAFILE 'E:\oracle\ERPORA\PM01.DBF' SIZE 1M ; alter database datafile 'E:\oracle\ERPORA\PM01.DBF' autoextend on maxsize unlimited ; create user test identified by test default tablespace student;僅供參考!
create tablespace student datafile 'd:\oracle\product\10.2.0\oradata\sid\student01.dbf' size 50M autoextend on next 1M maxsize unlimited; extent management local segment space management autocreate temporary tablespace temp_student tempfile 'd:\oracle\porduct\10.2.0\oradata\sid\temp_student01.dbf' size 50M autoextend on next 1M maxsize unlimited;create user test identified by test default tablespace student quota unlimited on student account unlock;grant connect,resource to test;在执行以上的四条SQL语句后,用户TEST就可以连接到数据库并可以创建数据库对象了.
跟着凑个热闹: CREATE TABLESPACE "student" LOGGING DATAFILE 带路径的文件名 SIZE 50M REUSE AUTOEXTEND ON NEXT 1024K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT MANUAL CREATE TEMPORARY TABLESPACE "temp_student" TEMPFILE 带路径的文件名 SIZE 20M REUSE EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024K;CREATE USER "test" IDENTIFIED BY "test" DEFAULT TABLESPACE "student" TEMPORARY TABLESPACE "temp_student" ACCOUNT UNLOCK
alter database datafile 'E:\oracle\ERPORA\PM01.DBF'
autoextend on maxsize unlimited ;
create user test identified by test default tablespace student;僅供參考!
datafile 'd:\oracle\product\10.2.0\oradata\sid\student01.dbf' size 50M autoextend on next 1M maxsize unlimited;
extent management local segment space management autocreate temporary tablespace temp_student
tempfile 'd:\oracle\porduct\10.2.0\oradata\sid\temp_student01.dbf' size 50M autoextend on next 1M maxsize unlimited;create user test identified by test
default tablespace student
quota unlimited on student
account unlock;grant connect,resource to test;在执行以上的四条SQL语句后,用户TEST就可以连接到数据库并可以创建数据库对象了.
CREATE TABLESPACE "student"
LOGGING
DATAFILE 带路径的文件名 SIZE 50M
REUSE AUTOEXTEND ON NEXT 1024K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT MANUAL CREATE
TEMPORARY TABLESPACE "temp_student" TEMPFILE
带路径的文件名 SIZE 20M REUSE EXTENT
MANAGEMENT LOCAL UNIFORM SIZE 1024K;CREATE USER "test"
IDENTIFIED BY "test" DEFAULT TABLESPACE "student"
TEMPORARY TABLESPACE "temp_student"
ACCOUNT UNLOCK