Re: database backup

dagnu wrote:

> Hi everybody,
>
> I'm not DBA, so i've got problem:
> I'd like to move my database to an other server (Oracle 8.1.7, Solaris
> 8); my database had dbf files on 2 partitions ...
>
> I've used this command: exp system/manager file=export.dmp full=y
> log=/log.txt
> But when i do the import, i retrieve dbf files only from the first
> partition :( (where there are the log, control files, etc ...)
>
> So, what is the best way to migrate a database !! export, import or
> copy files ?!
>
> Thanks to all (my question is not easy to answer !!)

I am very unclear about what you are doing and what you expect to happen. Log and control files are not exported and are not part of that process.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)