先备份dmp.
用UE直接修改dmp文件, 把表空间名称修改了,试试.
用UE直接修改dmp文件, 把表空间名称修改了,试试.
解决方案 »
- 调用存储过程出现:PLS-00103
- WINDOWS下打了震荡波补丁后,ORACLE的服务不能自动启动,只能在DOS下手动启动
- sum求和的小数问题
- Oracle 在原有的数据库中新建一张表,新表的字段和另一张已经有的表完全一样。只是名字不同。大侠帮帮忙,我新手!
- 全角字符,半角字符 匹配查找问题 解决再给200
- PL/SQL的矛盾!PL/SQL开发高手请进!
- 急!!!请问如何插入一条带有日期型的记录
- 你们是怎么建 表的。表空间是什么呀?说说你的建库,建表。和加记录的情况好吗?
- 帮忙啊!如何用orcale的存储过程作为数据窗口的数据源.
- 请教在oracle9i中有没有象sqlserver里面的dateadd()函数呀?
- 请问我想取出记录集的第30之60条记录,应该怎么写呢?我写成where rownum>30 and rownum<60为什么选不出来纪录呢?
- 导出时出错,各位看看
scott as an example and the tablespace will be DATA (was in USERS). exp userid=system/manager parfile=exp_user.par file=exp_scott.dmp
log=exp_scott.log
owner="(scott)" Parameter File: BUFFER=4096000
COMPRESS=Y
GRANTS=Y
INDEXES=Y
ROWS=Y
CONSTRAINTS=Y
DIRECT=Y Enter the following at the SQL prompt: revoke DBA,RESOURCE from scott; REM make sure they only have connect.
alter user scott quota unlimited on DATA;
alter user scott quota 0M on USERS;
alter user scott quota 0M on SYSTEM;
REM The last three grants give the user added privs that RESOURCE
was giving them. grant create procedure to scott;
grant create trigger to scott;
grant create type to scott; Now import the user: imp userid=system/manager parfile=imp_user.par file=exp_scott.dmp
log=imp_scott.log fromuser="(scott)" touser="(scott)" Parameter File: BUFFER=4096000
GRANTS=Y
INDEXES=N
IGNORE=Y
ROWS=Y I realize "Y" is the default for the parameters in the par file but
there are times you want to change them to "N" so I leave them in.
Once you have moved the user you can grant the privileges back to them.