Oracle扩展表空间提示

来源：互联网发布：众泰和知豆哪个好编辑：程序博客网时间：2024/05/19 23:15

1.在进行导入数据泵文件的时候出现

ORA-39171: 作业出现可恢复的等待。
ORA-01691: Lob 段 WGS.SYS_LOB0000132590C00003$$ 无法通过 8192 (在表空间 NNC_DATA01 中) 扩展

2.在网上找的扩展表空间

SQL> alter tablespace NNC_DATA01 add datafile 'F:\databackup\NNC_DATA01.DBF' autoextend on ;
第 1 行出现错误:
ORA-01537: 无法添加文件 'F:\databackup\NNC_DATA01.DBF' -
该文件已是数据库的一部分

3.Oracle官网给的扩展提示 https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_7003.htm

Creating Basic Tablespaces: Examples This statement creates a tablespace named tbs_01 with one datafile:

CREATE TABLESPACE tbs_01    DATAFILE 'tbs_f2.dat' SIZE 40M    ONLINE;

This statement creates tablespace tbs_03 with one datafile and allocates every extent as a multiple of 500K:

CREATE TABLESPACE tbs_03    DATAFILE 'tbs_f03.dbf' SIZE 20M   LOGGING;

Enabling Autoextend for a Tablespace: Example This statement creates a tablespace named tbs_02 with one datafile. When more space is required, 500 kilobyte extents will be added up to a maximum size of 100 megabytes:

CREATE TABLESPACE tbs_02    DATAFILE 'diskb:tbs_f5.dat' SIZE 500K REUSE   AUTOEXTEND ON NEXT 500K MAXSIZE 100M;

Creating a Locally Managed Tablespace: Example The following statement assumes that the database block size is 2K.

CREATE TABLESPACE tbs_04 DATAFILE 'file_1.f' SIZE 10M   EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K;

4.指定一个新的表空间文件

SQL> alter tablespace NNC_DATA01 add datafile 'F:\databackup\NNC_DATA02.DBF' SIZE 500M autoextend on ;表空间已更改。

5.会自动继续进行数据导入

0 0