Is there any free tool to convert export dump file into txt file?

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

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

---

define "txt file".

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

Quote:

---

Originally posted by raghud
or to easily migrate Schema to another servers like sql server or db2.

---

Yes.

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

---

There is no easy way to convert binary file into text file. You definitely need to export ( unload ) tables into text flat file. FastReader (www.wisdomforce.com) is not free, but not so pricy as similar from CA or BMC. FastReader extracting very quickly into text file and creates ctl file for loaders like sqlldr. Very convinient for large databases
Hope it hepls

Lily_Liu_2004 are you listening ???

I think he/she not checking after creating such a stupid like thread.

Dilip

Quote:

---

Originally posted by Lily_Liu_2004
Yes.

---

You can use like Data Transformation Services of SQLServer Enterprise Manager, as one of your option if you want to copy objects from Oracle to SQLServer.