Re: Porting Access tables into Oracle

> One more question. Is it possible to generate a " xxxx.sql" file from the
> oracle schema for backup purpose ?

You can create a SQL script to recreate your schema objects. Since you are on 9i, the DBMS_METADATA package can reverse-engineer your schema objects for you. However, it won't have your data.

You can use Oracle's export utility. This will contain all the SQL statements to recreate your objects and it will contain the data.

Finally, you can implement a solid backup and recovery plan. Please read the Oracle docs for more.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"