dont use import/export. Not for what you want. If you look up the 'utility' RMAN. That would be much better for you for various reasons. Its a standard Oracle product. RMAN is very easy to use and has loads of examples all over metalink and the net. After some basic setup, it will only take a 10 line script to backup your database and similar to restore if it all goes wrong. Also, you will need to back up the code tree - i.e. RMAN will only do the database. For the code tree, you will have to use an OS utility - like tar/zip if you are on linux Kent. -----Original Message----- From: ora-apps-dba-bounce@xxxxxxxxxxxxx [mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of Chase Gruezo Sent: 06 June 2006 11:11 To: ora-apps-dba@xxxxxxxxxxxxx Subject: Backup and Restore Hi, Just want to ask your opinion regarding backup and restore on 11i. What are the types of backup and restore on 11i? What would you recommend to a starter? Also are there any articles, tips and know how regarding this matter? I've been trying to search docs on metalink and I had little luck. I came across this article 230627.1: 9i Export/Import Process for Oracle Applications Release 11i, would you recommend this to a beginner. I'm overwhelmed just skimming through the page. Thanks, Chase -------------------------------------------------------- If you are not an intended recipient of this e-mail, please notify the sender, delete it and do not read, act upon, print, disclose, copy, retain or redistribute it. Click here for important additional terms relating to this e-mail. http://www.ml.com/email_terms/ --------------------------------------------------------