Generating DDL out of dump file
Hi all,
I need to generate DDL from a dump file which I could do using "IMP SCOTT/TIGER FILE=D:\ONCO05.DMP INDEXFILE=D:\TEST_DMP.SQL" but when I am using this command, I am not getting anything not even any error. Even when I tried to import the tables and data, nothing seems to be importing. Below is what I am trying:
C:\oracle\product\ora92\bin>imp scott/tiger file=D:\onco05.dmp indexfile=d:\test_dmp.sql
Import: Release 9.2.0.1.0 - Production on Tue Jan 25 13:31:21 2011
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options
Export file created by EXPORT:V09.02.00 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
export client uses US7ASCII character set (possible charset conversion)
C:\oracle\product\ora92\bin>
Any thoughts?
TIA,
Onkar
Note : OS : Win XP
DB Ver : Oracle 9i (9.2.0.1.0)
I have two instances (9i & 10g) running on my system. I am running IMP utility from Oracle9i ORACLE_HOME. Even Tried to run the same command on a system which has only Oracle 9i (9.2.0.1.0)