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
Received on Mon Dec 27 2004 - 01:59:15 CST
