Re: HELP - Export/Import version 8.05

hpuxrac wrote:
> Julie here's the contents of the URL that I cited ...
>
> I can't vouche for it entirely but at a quick glance it looks fairly
> reasonable to me. Ed Stevens is I believe the author of this.
>
> *******************************************************************************************************
>
> Posting this mostly as a reference in case anyone searches the archives
>
> with a similar problem. Following up on a thread I started a few days
>
> ago.
>
> Task is to clone a schema. The first difficulty came with
> FROMUSER=schema-A TOUSER=schema-B, in that we want each schema to have
> it's own tablespace, but the DDL in the .dmp file had hard-coded
> tablespace references to the TS of the original exported objects.
> Various solutions found on the web involved extracting the DDL from the
>
> .dmp file and messaging it by hand, correcting the tablespace
> references and adding the statement terminators. This became untenable
>
> when it was found that with several hundred DDL statements, some were
> contained on a single line, and others were broken (sometimes badly)
> across multiple lines. The solution is in the use of the 'indexfiles'
> parm on import. It produces a text file of good, usable DDL that is
> easily edited with global changes to a usable file for initially
> creating the tables and indexes. Here's the full sequence:
>

--snip sequence--

additionally:
OP can possibly use DDL wizard to do the same (Create schema objects). I had used it some while back and believe it would allow you to filter out
tablespace names fairly easily.

http://www.ddlwizard.com/

Anurag Received on Fri Jan 05 2007 - 13:27:49 CST