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安装成功后Net Manager配置测试时报错!急求
- 关于视图创建触发器
- 如何减小已经创建表占用的表空间大小?
- oracle开发JAVA存储过程,怎么引入外部的JAR包??
- 求一个sql的写法
- 我安装完Oracle数据库后,总是连接不上
- [求救]我要在函数中进行Insert into 操作,并返回一个整数,写好了不知道如何调用?
- 高分求助(一定给!)SQL问题,在线等待!!!
- oracle中JOB的NEXT_DATE怎么修改
- 急问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 :
进入 之后~
数据库名 -> 存储 -> 空间 -> 你的用户名-> 数据文件(选中之后) 就可以查看.
.................................. 右键还可以新建表空间...