Restore schema
616546Feb 8 2008 — edited Feb 8 2008Hi,
We're building an application which supports a variety of databases. One of the features of the application is restoring a previously made dump of a database and for MSSQL this is working just fine using the 'restore database <name> from disk=<filename> with replace. Tests using a dumpfile of around 30MB show the database is restored in no more than 10 seconds.
I've tried to build similar functionality in Oracle 10g XE and used the DBMS_DATAPUMP api to do so. The dumpfile for a schema containing the same information as in MSSQL is only 6MB but it takes Oracle more than 40 seconds to import the schema. Is there a faster way to do this?
Any help is greatly appreciated.
Stevie