新建一个用户:sysjyptdba
新建表空间:sysjypt新建表:XTZT在pl/sql中 可以查询到表 select * from xtzt;但是在程序和sqlplus中都显示表或视图不存在
新建表空间:sysjypt新建表:XTZT在pl/sql中 可以查询到表 select * from xtzt;但是在程序和sqlplus中都显示表或视图不存在
解决方案 »
- oracle 10i 导出来的dmp文件,怎么导到oracle9i里
- oracle 存储过程问题
- 如何从oracle9i中导出数据库脚本
- 关于oracle9i的apache的启动问题,在线等
- 请详细谈论"行锁","表锁"等等
- 没有人挑战200分吗》》SQL->Orcale转换的问题
- 求助,怎么在p4上安装oracle9i AS?
- 一样的代码,一样的库结构,在sqlserver中可以,在oracle不可以
- java怎样调用能返回的多个数据集的oracle存储过程?--送 100 分
- 请问关于Long型
- 命令窗口执行存储过程的问题。在线等
- select 非常快,insert into select 非常慢
赋予执行的权限了:grant select on xtzt to sysjptdba;
grant connect to lbidw_axb;
grant dba to lbidw_axb;
grant resource to lbidw_axb;-- Grant/Revoke system privileges
grant alter any index to lbidw_axb;
grant alter any sequence to lbidw_axb;
grant alter any table to lbidw_axb;
grant alter any procedure to lbidw_axb;
grant alter tablespace to lbidw_axb;
grant create any context to lbidw_axb;
grant create any index to lbidw_axb;
grant create any library to lbidw_axb;
grant create any procedure to lbidw_axb;
grant create any table to lbidw_axb;
grant create any type to lbidw_axb;
grant create any view to lbidw_axb;
grant create procedure to lbidw_axb;
grant create public database link to lbidw_axb;
grant drop any index to lbidw_axb;
grant drop any library to lbidw_axb;
grant drop public database link to lbidw_axb;
grant execute any operator to lbidw_axb;
grant execute any procedure to lbidw_axb;
grant insert any table to lbidw_axb;
grant select any table to lbidw_axb;
grant unlimited tablespace to lbidw_axb;
授权吧
----------------------------------提示表或视图不存在,我在plsql中看见XTZT表已经在 sysjyptdba 的表空间内了。
grant connect to SYSJYPTDBA;
grant dba to SYSJYPTDBA;
grant resource to SYSJYPTDBA;-- Grant/Revoke system privileges
grant alter any index to SYSJYPTDBA;
grant alter any sequence to SYSJYPTDBA;
grant alter any table to SYSJYPTDBA;
grant alter any procedure to SYSJYPTDBA;
grant alter tablespace to SYSJYPTDBA;
grant create any context to SYSJYPTDBA;
grant create any index to SYSJYPTDBA;
grant create any library to SYSJYPTDBA;
grant create any procedure to SYSJYPTDBA;
grant create any table to SYSJYPTDBA;
grant create any type to SYSJYPTDBA;
grant create any view to SYSJYPTDBA;
grant create procedure to SYSJYPTDBA;
grant create public database link to SYSJYPTDBA;
grant drop any index to SYSJYPTDBA;
grant drop any library to SYSJYPTDBA;
grant drop public database link to SYSJYPTDBA;
grant execute any operator to SYSJYPTDBA;
grant execute any procedure to SYSJYPTDBA;
grant insert any table to SYSJYPTDBA;
grant select any table to SYSJYPTDBA;
grant unlimited tablespace to SYSJYPTDBA;
执行完了还是不行,为什么啊?
--看一下表的所有者是谁
select owner from dba_all_tables where table_name = 'XTZT';
------------------------
OWERSYS您说对了,我怎么解决呢?谢谢
imp system/manager file= <dmpfile> fromuser=SYS touser=SYSJYPTDBA---------------------------
请问file怎么填写?
你的表确定是要建在 sys 用户下而不是应该建在 sysjyptdba 用户下吗?
我觉得应该是要建在自己的用户下才符合程序设计,你可以把表重新以 sysjyptdba 用户创建一下就可以了如果必须要跨用户访问的话,则只能使用 owner.object 这样的方式,或者你在 sysjyptdba 用户下创建同义词
create or replace synonym xtzt for sys.xtzt;select * from xtzt;
file=目录/名称 例如 file=c:\backup\dmpfile.dmpc:\backup 目录必须存在,dmpfile.dmp 则为备份文件名和后缀