Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Export / import of a db
DMina_at_laiki.com wrote:
> Hello people!
>
> I need to export our production Oracle database (8.1.7.4) on AIX (5.2)
> and import it into our preproduction environment. This is the statement
> I am planning to use for the export:
>
> exp user/password file=prod.dmp consistent=y full=y log=prod.log
>
> The issue is that the preproduction database has a different structure
> from the production database.
> In the preproduction database there are different tablespaces and more
> in number. How do I go about this?
> How should/can i proceed? What do i have to have in mind?
>
> Regards,
> Demetris
How big is it?
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Tue May 31 2005 - 00:48:52 CDT