Re: Clean Static Table Import.

Brandon Duncan wrote:
>
> To any Oracle Experts:
>
> ORACLE is not something I use everyday. I know how to export a group of
> static tables to a
> .dmp file using the ORACLE 8 GUI Export. What I don't know is the PL/SQL
> commands to import this
> .dmp file either to the same User/TableSpace or to another User/TableSpace.
> Could someone tell
> me how to do this? More importantly, is this the proper method to
> accomplish my task. If not,
> what is the best method?
>
> Thanks for you help,
>
> Brandon

        You don't need PL/SQL.

1. Run your export.
2. Create empty tables in the new tablespace.
3. Drop the original tables.
4. Run the following from the command line:

        imp <user>/<password> ignore=y fromuser=<username> touser=<username>

--
Jerry Gitomer
Once I learned how to spell DBA, I became one Received on Mon Mar 27 2000 - 23:23:23 CST