你用svrmgr+internal用户试验一下
SVRMGR30>connect internal
svrmgr30>@...catexp7.sql
SVRMGR30>connect internal
svrmgr30>@...catexp7.sql
解决方案 »
- 高分求助,Oracle Data Provider.net Oracle10g,在VS2010中如何安装使用
- insert /*+ append */ into select如何使用啊?
- 正在执行查询时候,数据发生变化会出现什么情况
- 表空间如何迁移?
- orecle在线急问```````
- 日期比较,请看内容。谢谢!
- 一个小问题?
- 100分—————请教——————怎样向 RAW 类型字段插入值(在线等,有答案立刻结)
- 问一个基础问题,不要笑我
- !!**Oracle9i的Java存储过程中访问外部文件的问题!请高手帮忙!
- ORACLE安装问题
- 紧急:ORACLE817不能安装于XEON的问题。在线等待。
run $ORACLE_HOME/rdbms/admin/catexp7.sql as other catalogs,
which creates needed views for export7. oracle engineer:
Minna is right, this is possible. However, you are getting the errors because the V7 export is expecting a difference in it's views. These can be created in the 8.1.6 databases using catexp7.sql provided with the Oracle8i release. 所以我觉得是权限问题
1. At a DOS prompt, Set oracle_sid=<SID>. Then, run SVRMGR30.
2. Inside Server Manager, connect as SYS or INTERNAL.
3. Run the "catexp7.sql" script. This script is in the [$ORACLE_HOME]\rdbms80\admin directory. NT: Exporting from Oracle8, Importing Into Oracle7 ================================================== Solving this problem involves using the Oracle7 export utility to export data from an Oracle8 database. To do this, the Oracle7 export utility has to be able to connect to the Oracle8 database. In addition, the Oracle8 database export must be configured so that the export dump file produced will not contain any Oracle8-specific objects, and therefore be similar to an Oracle7 export dump. Overall, this issue is platform generic. However, there are a few minor differences between exporting and importing in an NT or UNIX environment. For one, you do not need to configure any environment variables on NT. The NT registry need not be changed. Second, export and import utilities on NT are suffixed with the version number (ie. exp73 or imp73 in the case of export and import utility for version 7). A case may arise where data needs to be transferred from a V8 database in one location to a V7 database in another location. In this case, either of two things needs to occur: (1) The V8 database can connect remotely to the V7 database, or, (2) a copy of the oracle V7 database is available locally. In the first case, do the following: On the V8 Instance Machine: 1. At a DOS prompt, Set oracle_sid=<SID>. 2. Then, run SVRMGR30. 2. Inside Server Manager, connect as SYS or INTERNAL. 3. Run the "catexp7.sql" script. This script is in the [$ORACLE_HOME]\rdbms80\admin directory. On the V7 Instance Machine: 1. Make sure that "tnsnames.ora" at the V7 database machine is setup to connect to the V8 database. For example: v8db.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = [v8machine_name] or [v8 IP Address]) (Port = 1521) ------------- check listener.ora for correct port number in the v8 oracle_home/net80/admin ) ) (CONNECT_DATA = (SID = [Instance_name]) ------------------V8 Instance Name ) ) Check the connection using SQL*Plus (eg. sqlplus v8user/password@v8db). 2. At the DOS prompt, run the V7 export utility (exp73) for example: EXP73 [v8dba_user]/[password]@v8db FILE=d:\orant\dump_filename FULL=Y LOG= d:\orant\...., etc 3. Once the export dump file is created, run the V7 import utility (imp73). For example: IMP73 [v7dba_user]/[password] FILE=d:\orant\... LOG=d:\orant\.., etc... In the second case the procedure followed is the same as the one outlined above, except that the export dump file, once generated, must be moved/copied to the remote Oracle7 instance. Once the dump file is moved to the remote Oracle7 instance, the import can be performed.