Cause: The table or view entered does not exist, a synonym that is not allowed here was used, or a view was referenced where a table is required. Existing user tables and views can be listed by querying the data dictionary. Certain privileges may be required to access the table. If an application returned this message, the table the application tried to access does not exist in the database, or the application does not have access to it. Action: Check each of the following: The spelling of the table or view name.
That a view is not specified where a table is required.
That an existing table or view name exists.
Contact the database administrator if the table needs to be created or if user or application privileges are required to access the table.
Also, if attempting to access a table or view in another schema, make certain the correct schema is referenced and that access to the object is granted
That a view is not specified where a table is required.
That an existing table or view name exists.
Contact the database administrator if the table needs to be created or if user or application privileges are required to access the table.
Also, if attempting to access a table or view in another schema, make certain the correct schema is referenced and that access to the object is granted
解决方案 »
- oracle expdp与exp 的速度问题
- com组件打开oracle连接出未指定的错误
- 有关pl/sql的一些问题
- ORACLE数据库解锁问题
- 安装maximo 导入数据时,出现的问题?
- oracle 安装问题
- 高分求救oracle 8.1.6不能正常启动问题!!!
- 关于oralce函数的写法? select getStr( product_model) from table 1, 返回的是 产口的型号,如(SD1, SG2, SJ3),在线等
- 一个sql问题,请进
- 怎样使solaries系统启动时,使ORACLE数据库的第二个数据库实例起来?
- 9I在内存256M下是如此的慢,慢的让人分特!!!!!
- 请问在Solaris中,是否可以通过编程(最好是shell)自动配置Oracle客户端?
1.使用system/manager@服务名登陆
connect system/manager@服务名
2.给system自己赋予角色EXP_FULL_DATABASE和IMP_FULL_DATABASE角色
grant exp_full_database to system;
grant imp_full_database to system;
3.在SYSTEM用户下EXP数据
c:\>exp80 system/manager@服务名
接着交互式导出数据哈哈,给分吧