Hi all,
Is there any free tool which can convert the export dump file
into txt file?
Thanks,
Lily
Hi all,
Is there any free tool which can convert the export dump file
into txt file?
Thanks,
Lily
no since the dumps is banary.
you can do an import with show=y but it won't show data
strings
www.databee.com has one if rows=n
define "txt file".Quote:
Originally posted by Lily_Liu_2004
Hi all,
Is there any free tool which can convert the export dump file
into txt file?
Thanks,
Lily
Do you mean "convert the data to SQL commands" or do you mean "Create the ddl to create the structures?"
Also define "FREE" (just kidding...)
errrrr ummm
indexfile=yourfile.txt gives all the ddl commands.
He is requesting for a tool that converts dump file to text . not indexfile=//...txt. I think what he mean is all ddl statements and all insert/update statements to recreate the schema with data. or to easily migrate Schema to another servers like sql server or db2.
If this is the case I think we need to contact www.oracle.com (President Oracle corp Nasdaq code:Orcl)
ummm strings on unix will do precisely that
Yes.Quote:
Originally posted by raghud
or to easily migrate Schema to another servers like sql server or db2.