Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Export / import of a db

Re: Export / import of a db

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 31 May 2005 06:36:17 -0700
Message-ID: <1117546447.462774@yasure>


DMina_at_laiki.com wrote:
> The database size is approximately 58GB (used space) and the exported
> dump file is 28GB

I don't like any of the answers that quickly come to mind ... so here's what I'd do.

  1. Create the exact same tablespaces that previously existed
  2. Import into a schema created temporarily just for the import
  3. Move the data to the desired storage locations in the final schema
  4. Dump the temporary schema
  5. Dump the extra tablespaces

A pain but it solves the problem and protects you against many possible accidents.

But if someone has a better idea, and I hope they do, I'd like to hear 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 - 08:36:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US