如何在oracle中创建表 [英] how to create tables in oracle

问题描述

全部受推荐，

我想在我创建的oracle数据库中创建一个表.但是，当我尝试从vb.net中的表访问数据时，会发生以下错误.
''表或视图不存在.
这表示我的数据库已连接.

我该怎么做，请帮助我.

谢谢

Respected all,

I want to create a table in my oracle database i create it. But when i trying to access data from that tables in vb.net then following error occur.
''Table or view does not exist.
It means my database is connected.

How i can do it please help me.

Thank you

推荐答案

问题是您无法使用客户端程序中使用的凭据访问表.

• GRANT [同义词 [^ ]
• 或为查询中的表定义所有者架构，例如
  

The problem is that you don''t have access to the table using the credentials you have used in you client program.

• GRANT[^] proper privileges to the user (or role) that you use to connect to the database
• either create a public synonym[^] for the table
• or define the owner schema for the table in your query, for example
  

select ... from owner.tablename where...

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