Re: Export and Import and Referential Integrity Constraints

Boo wrote:
>
> Running Oracle 8.0.5 on Solaris 2.7.
> Is there any reasons why, when moving a database with quite a few
> referential integrity constraints to a new server, that the
> export/import option
> can't be used?
> My understanding is, if it's a fresh database built on the new server,
> and doesn't have existing data, than an export/import should not pose
> any problems.
>
> TIA
I'd like to recommend following methodic:

1. Disable all jobs.
2. Restart oracle in restricted mode
3. Export FULL=Y ROWS=N CONSTRAINTS=Y STATISTIC=COMPUTE (full export w/o rows, i.e. all meta-data)
4. Export FULL=Y ROWS=Y CONSTRAINTS=N (all data) You can export data by parts - 8.0.5 for some platforms couldn't accept dmp files>2Gb 8-(((((
5. Create empty database with all tablespaces (you can change datafiles)
6. Import p.4
7. Import p.3

Good idea after that start both databases and compare (via dblinx) ALL_OBJECTS as SYS.
This scheme is brief, experience needed to do everything w/o mistakes... Good luck 8-)

• Best regards, Igor Ushkalo (igorus!) - igorus(at)mail.ru, ICQ #19972198