表没有看到 [英] Tables not seen

问题描述

我使用.bat文件在数据库中创建了我的表但是当我尝试使用toad将数据/值插入其中时会出现提示，表示我刚创建的表不存在但是当你查看模式时浏览器标签表就在那里..我错过了什么吗？您认为这个问题是什么？非常感谢任何帮助..


非常感谢

解决方案

你能从TOAD和SQL * PLUS的表中查询吗？您在insert语句中使用的表名是否正确？表名中没有奇怪的字符？确切的表名是什么？


Pilgrim。

tnx Pilgrim，


没有表名中的奇怪字符，我确定名称是正确的。我刚尝试了在SQL plus中使用Toad的相同查询，并且它工作正常。你认为我的蟾蜍的问题是什么？


非常感谢..

你需要检查以下内容：


1.在哪个Schema中创建了一个表？

2.您是否在创建表的TOAD中登录到相同的模式？

3.尝试通过在表名之前附加其所有者来查询该表。比如说


例如：如果您在APPS模式中创建了一个表，那么查询一个表，说明


从APPS中选择*。< table_name> ;

I have created my tables in a database using a .bat file but when I try to insert data/values into it using toad there is prompt occuring that says that table i just created does not exist but when you look at the schema browser tab the table is there.. Did I miss something? What do you think is the problem? Any help is much appreciated..

Many thanks

解决方案

Hi,

Can you query from the table from TOAD and SQL*PLUS? Is the table name you are using in your insert statement correct? No weird chars in the table name? What is the exact table name?

Pilgrim.

tnx Pilgrim,

There are no wierd characters in the Table name and Im sure that the name is correct. I just tried the same query that I used in Toad in SQL plus and it worked. What do you think is the problem of my Toad?

Many thanks..

You will need to check the following:

1. In Which Schema you created a table?
2. Are you logging in to same schema in TOAD in which you created a table?
3. Try querying that table by appending its owner before table name. Say for

Eg: if you created a table in APPS schema then query a table by saying

Select * from APPS.<table_name>

这篇关于表没有看到的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！