Re: PO7 export/import

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 5 Jan 2005 09:53:11 -0800
Message-ID: <1104947591.700752.133100@c13g2000cwb.googlegroups.com>

himanshu.saini_at_gmail.com wrote:
> We are porting a windows based application from SQLBase to Personal
> Oracle 7.3.3.0.0. One of the impacted areas is the backup/restore
> functionality of the application. In SQLBase the backup was taken in
> form of SQL statements( for both DDL and data) which could be
executed
> to restore the database. AFAIK the export/import utilities shipping
> with PO7 use OS independent binary files. Is there some other utility
> which I don't know of which can be used to export data in form of a
> dump of sql statements or is spooling from SQL*Plus the only option?
If
> not, will using the binary-oriented export/import utilities have any
> advantage performance wise over SQL*Plus spooling and SQL*Loader
> loading for a small database like ours? it has some 44 tables and the
> number of records in them varies from 100 to 5000?
> Thanks in advance,
> Himanshu

If you were not using the long-ago-desupported Oracle release, you could use tools like PL/SQL Developer from http://www.allroundautomations.com/plsqldev.html. It has point-and-click option to do exactly what you want in a small size database... i.e. Generate Sql inserts with DDL's where all the punctuation is taken care of.

Regards
/Rauf Received on Wed Jan 05 2005 - 11:53:11 CST