Re: Help on partition managing

On Mon, 22 Jul 2002 13:42:46 GMT, "Enkidu" <utnapishtim43NOSPAM_at_hotmail.com> wrote:

> May I make a suggestion. I assume that since you have an export file. you
>also have access to the source database (unless you're receiving the export
>file from a 3rd party). If you do have access to the source database, it's
>far easier to build a dynamic sql script that uses the DBA_% views to
>generate scripts to rebuild objects on your target database. If you're
>receiving the export file from someone else and don't have access to the
>source database, then vi is as good as anything else.

The only thing that needs to be done is run imp show=y log=<filename> and you will end-up with an ascii file which you can edit. You DON'T NEED access to the source database for that, and you can use ANY username/password combo
Using vi on a dmp file is 100 percent dangerous! It should NOT be advised to ANYONE, and there is NO NEED for it.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Jul 22 2002 - 12:53:56 CDT