1、以system用户登陆,查看dba_tablespaces视图了!!
2、create tablespace 表空间名
datafile '路径\数据文件.dbf' size 5m
default storage (initial 10k next 50k);
自己还要看看书了
2、create tablespace 表空间名
datafile '路径\数据文件.dbf' size 5m
default storage (initial 10k next 50k);
自己还要看看书了
解决方案 »
- oracle global_name问题 高手请帮忙解决!高分!
- Oracle中的一个bug求解
- 请帮忙看句SQL要如何实现
- IN CHAR的问题
- proc*中传入的字符串数组如何转化为sql查询条件?请大家帮忙,谢谢
- oracle查询语句问题sql...急!!!在线等
- 关于Oracle的多对多查询的问题,谢谢。
- update的问题困扰了我好久,请高手指点
- 我的存储过程里需要解压缩.tar文件,怎么办?
- oracle 新手求助
- 急问oracle 的agent服务为什么启动不了?
- 我在sql*plus 中执行sql语句建表时 报错ERROR 位于第 1 行: ORA-18008: 无法找到 OUTLN 方案
DATAFILE Datafile_Options Storage_Options ;Datafile_Options: 'filespec' [AUTOEXTEND OFF]
'filespec' [AUTOEXTEND ON [NEXT int K | M] [MAXSIZE int K | M]]
The Autoextend Maxsize clause will default to UNLIMITED if no value is specified. Storage_Options: DEFAULT STORAGE storage_clause
MINIMUM EXTENT int {K|M}
LOGGING | NOLOGGING
ONLINE | OFFLINE
PERMANENT | TEMPORARY
EXTENT MANAGEMENT {DICTIONARY |
LOCAL {AUTOALLOCATE | UNIFORM [SIZE int K | M]} }"A place for everything and everything in its place" - Isabella Mary Beeton, The Book of Household ManagementRelated Commands:ALTER TABLESPACE
DROP TABLESPACE Related Views: DBA_DATA_FILES
DBA_TABLESPACES USER_TABLESPACES
DBA_TEMP_FILES
DBA_TS_QUOTAS USER_TS_QUOTAS
ALTER TABLESPACEChange the properties of a tablespace.Syntax: ALTER TABLESPACE tablespace_name option
options:
The option used with this command can be any one of the following
ADD {TEMPFILE|DATAFILE} 'filespec' [AUTOEXTEND OFF] SIZE int {K|M} ADD {TEMPFILE|DATAFILE} 'filespec' SIZE int {K|M}
[ AUTOEXTEND ON [NEXT int K | M]
[MAXSIZE {UNLIMITED|int K|int M}] ] RENAME DATAFILE 'filename' TO 'filename'
MINIMUM EXTENT int {K|M}
COALESCE
DEFAULT STORAGE storage_clause
ONLINE
OFFLINE {NORMAL | TEMPORARY | IMMEDIATE | FOR RECOVERY}
{BEGIN | END} BACKUP
READ {ONLY | WRITE}
PERMANENT | TEMPORARY
LOGGING | NOLOGGING"God grant us the serenity to accept the things we cannot change, courage to change the things we can, and wisdom to know the difference." - Reinhold Niebuhr - The 12 step program Related Commands:DBMS_SPACE_ADMIN
CREATE TABLESPACE
DROP TABLESPACERelated Views: DBA_DATA_FILES
DBA_TABLESPACES USER_TABLESPACES
DBA_TEMP_FILES
DBA_TS_QUOTAS USER_TS_QUOTAS
DROP TABLESPACECreate a tablespace.Syntax: DROP TABLESPACE tablespace_name [INCLUDING CONTENTS [CASCADE CONSTRAINTS]]"I am become death, shatterer of worlds." - Robert J. Oppenheimer (citing from the Bhagavad-Gita, after witnessing the world's first nuclear explosion) Related Commands:CREATE TABLESPACE
ALTER TABLESPACE Related Views: DBA_TABLESPACES USER_TABLESPACES
DBA_TS_QUOTAS USER_TS_QUOTAS
在 DBA Studio :
进入 之后~
数据库名 -> 存储 -> 空间 -> 你的用户名-> 数据文件(选中之后) 就可以查看.
.................................. 右键还可以新建表空间...