Re: Problem with offline restore of a database

nkamkar28_at_gmail.com wa:
>Can anyone advise or point e inthe right direction of how to restore
>this database on the new server.

This can be done a number of ways, depending on your setup and your level of expertise (...). Google the following for more information:

• expdp/impdp (10g+), exp/imp (9i and lower)
• transportable tablespaces
• RMAN can do backups (may be a little complex for novices, though)
• basic file copy of necessary DB files

You should tell us your oracle database version for a more detailed reply.

-- 
"Care must be exorcised when handring Opiticar System as it is apts to
be sticked by dusts and hand-fat." --Japanese Translators

"Keep your fingers off the lens." --Elton Byington, English Translator