Question

我正试图导出11号甲骨文中的数据

exp user/password file=dump.dmp tables = (table1)

通过 sqlplus 。

我发现以下错误:

About to export specified tables via Conventional Path ...
EXP-00011: USER.TABLE1 does not exist
Export terminated successfully with warnings.

但当我检查谁是这张桌子的主人时:

SELECT owner, table_name from dba_tables where table_name =  TABLE1 ;

我知道 Table1 的所有人是 USER

我该如何出口这张桌子?

UPDATE

Actually, i found a solution. I hope it will help someone else. Since version 11g Oracle has introduced new feature that is called deferred segment creation. Thus oracle doesn t create table segment if there are now rows in it. So i recreated my table with option segment creation immediate

Answer 1

事实上,我找到了一个解决方案。我希望它会帮助别人。自从版本 11 版本甲骨文 11 引入了新特性, 称为延迟段创建。因此, 甲骨文没有行就不会创建表格段。我的表格没有包含任何数据。因此, 我立即用选项段创建重新创建了我的表格。

找到的解决方案这里。有更多的选项可以解决这个问题,并解释为什么这东西碰巧在11g. :

Answer 2

除了Olivia的回复之外,

SELECT  alter table   ||  table_name ||   allocate extent; 
from dba_tables where SEGMENT_CREATED =  NO ;

执行输出和解析。您的方案将导出包含空表格的输出。

EDIT: similar question here, maybe you ll find your solution there.

Answer 3

更改此更改 :

exp user/password file=dump.dmp tables = (table1);

与此相关的:

exp user/password tables = (table1) file=dump.dmp;

Answer 4

您可以在下面的查询中从特定用户导出表格级别。

exp user/password file=dump.dmp tables = user.table1

UPDATE

友情链接