Re: Full Import

From: <kcary_at_my-deja.com>
Date: Fri, 16 Jul 1999 20:33:17 GMT
Message-ID: <7mo4ue$q91$1@nnrp1.deja.com>

In article <378cfb94.13598156_at_news.siol.net>, jmodic_at_src.si (Jurij Modic) wrote:
>
> Strictly answering the question: you should only run the CREATE
> DATABASE command following by running the CATALOG.SQL and CATPROC.SQL.
> This should create both the SYSTEM tablespace, redo logs and the
> database dictionary. All the other stuff, including the rollback
> segments definition , tablespace definitions and users specifications
> are exported during the full export and should be recreated during the
> full import (if everything goes OK).
>
> However, I agree with Thiru (tmgn_at_excite.com), I personally would
> precreate at least all the tablespaces manually.
>

Wow, this has been a great thread. May I ask if there is a way to take a 'snapshot' of the tablespaces, generating a sql file, reflecting the running database. The idea would be to save this file to assist in the reconstruction of the database tablespaces before import.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jul 16 1999 - 15:33:17 CDT