-
DDL for tables using indexfile
I'm after the DDL for creating tables using the INDEXFILE option for imp, However I'm still getting broken lines in the file - column names are spilt across lines, giving me an error when running the script:
e.g
REM ("OWNER","IPADDR_BYTE1","IPADDR_BYTE2","IPADDR_BYTE3","IPADDR_BY
REM TE4_UPPERLIMIT","IPADDR_BYTE4_LASTUSED") USING INDEX
Does anyone know anyway to get round this?
Using 8.1.6 on Sun 5.8
Thanks,
-
Have also tried the import on a 9.2.0.3 database but get the same problem so I dont think it can be a version issue
-
Can anyone suggest a way to extract table DDL from an 8.1.6 database if the indexfile approach isnt valid?
-
Take a look at the free version of DataBee from the following
http://www.databee.com/
It's a quick an easy method of extracting DDL from export files.
HTH
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
...Or if you have a 9i database you can use the DBMS_METADATA package.
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
Unfortunately we're stuck at 8.1.6 as its a third part application! For anyone whos interested it seems to be a version problem - according to Tom Kyte the problem was fixed at 8.1.7 and he cant think of a work around so I'm pretty much up the creek I think! Will have a look at databee and see if thats any help.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|