NEVER edit the export file.
You can do a full export, and import with indexfile=<filename>. Then edit
<filename> to change the tablespace names for those tables you want to move.
Use <filename> to pre-create the tables and then rerun import with ignore=y.
This will load the the data without trying to create the tables (which you
have just created in their new tablespace).
Granted, it takes a few extra steps, but you're doing it "by the book".
Mike
Jeff wrote in message ...
>First of all let me say that I am new to Oracle and am currently interning.
>So I apoligize for my green side. The Senior DBA has asked me to search
>for a way to edit the Oracle 8.05 export dump file. The reason being is
>that we are going to re-organize by creating new tablespaces by editing
>the export file by changing the tablespaces for the chosen tables. The
>reason we are doing this is to improve disk optimization. My Senior has
>told me that editing the export file is very time consumming. The export
>itself is also very large with numerous tables(PeopleSoft over a 1000
>tables). The export file will then be imported with the new tablespaces
>being created. My understanding of this problem is that the export dump
>file is in a text wrap mode that makes editing a problem.
>
>Has anyone have any suggestions or any tools to help aid in editing the
>export dump file?
>Our operating system is Unix (IBM AIX )and the database resides on a RS6000
>
>--
>Posted via CNET Help.com
>http://www.help.com/
Received on Fri Mar 03 2000 - 00:00:00 CST
