ORACLE 11G 导出报错(EXP-00003)未找到段 (0,0) 的存储定义

版权声明:本文为博主原创文章,遵循 CC 4.0 by-sa 版权协议,转载请附上原文出处链接和本声明。
本文链接:https://blog.csdn.net/qq_19524879/article/details/51313205

ORACLE 11G 导出报错(EXP-00003)未找到段 (0,0) 的存储定义


具体原因网上百度很简单

下面是解决办法

select 'alter table '||table_name||' allocate extent;' from user_tables where num_rows=0;


然后吧生成的 alter table P_SBS_WGJ_QYRJZBHSFDWJL_01_A allocate extent; 放在 命窗口执行


语句查出来的不一定是全部的 所有导出的时候再有 EXP-00003未找到段 (0,0) 的存储定义 


你可以单独拷贝出来那个表名 然后 alert 语句执行以下 (注:可能会有漏掉的我都遇到过了)


展开阅读全文

Oracle 11g连接报错

04-07

我在Windows xp 系统中装了oracle 11g 刚开始用还挺好,rn现在就出现问题了,报错说监听不到rnORA-12505: TNS: 监听程序当前无法识别连接描述符中所给出的 SID (DBD ERROR: OCIServerAttach)rn我的listener.ora文件如下:rn# listener.ora Network Configuration File: E:\app\Administrator\product\11.1.0\db_1\network\admin\listener.orarn# Generated by Oracle configuration tools.rnrnLISTENER_ORCL =rn (DESCRIPTION_LIST =rn (DESCRIPTION =rn (ADDRESS = (PROTOCOL = TCP)(HOST = PC2011010515KNT)(PORT = 1521))rn )rn )rnrnLISTENER =rn (DESCRIPTION_LIST =rn (DESCRIPTION =rn (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))rn )rn (DESCRIPTION =rn (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.103)(PORT = 1522))rn )rn )rn我的sqlnet.ora文件如下:rn# sqlnet.ora Network Configuration File: E:\app\Administrator\product\11.1.0\db_1\NETWORK\ADMIN\sqlnet.orarn# Generated by Oracle configuration tools.rnrn# This file is actually generated by netca. But if customers choose to rn# install "Software Only", this file wont exist and without the native rn# authentication, they will not be able to connect to the database on NT.rnrnSQLNET.AUTHENTICATION_SERVICES= (NTS)rnrnNAMES.DIRECTORY_PATH= (NIS, TNSNAMES, EZCONNECT, HOSTNAME)rnrn我的tnsnames.ora文件如下:rn# tnsnames.ora Network Configuration File: E:\app\Administrator\product\11.1.0\db_1\NETWORK\ADMIN\tnsnames.orarn# Generated by Oracle configuration tools.rnrnUsers =rn (DESCRIPTION =rn (ADDRESS_LIST =rn (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.103)(PORT = 1522))rn )rn (CONNECT_DATA =rn (SERVER = DEDICATED)rn (SERVICE_NAME = Users)rn )rn )rnrnTORCL =rn (DESCRIPTION =rn (ADDRESS_LIST =rn (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.106)(PORT = 1522))rn )rn (CONNECT_DATA =rn (SERVER = DEDICATED)rn (SERVICE_NAME = TORCL)rn )rn )rnrnTESTDB2 =rn (DESCRIPTION =rn (ADDRESS_LIST =rn (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.106)(PORT = 1522))rn )rn (CONNECT_DATA =rn (SERVICE_NAME = TESTDB)rn )rn )rnrnrnORCL =rn (DESCRIPTION =rn (ADDRESS_LIST =rn (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.106)(PORT = 1521))rn )rn (CONNECT_DATA =rn (SERVER = DEDICATED)rn (SERVICE_NAME = ORCL)rn )rn )rn说明,我的tnsnames.ora文件中已经连接到一个数据库rn可不可以连接两个数据库,在tnsnames.ora文件中。rn请高手指点,急,谢谢rnrn 论坛

没有更多推荐了,返回首页