Re: Oracle 7:moving tablespaces

From: Alex Filonov <afilonov_at_yahoo.com>
Date: 2 Jun 2003 08:37:04 -0700
Message-ID: <336da121.0306020737.7005d985@posting.google.com>

Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote in message news:<7juedv8g933g944lids39itbo2vuhac3dk_at_4ax.com>...
> On Fri, 30 May 2003 11:00:38 -0400, "Hoang C" <hoang_c_at_bls.gov> wrote:
>
> >I think data is still point to old tblspace after importing.
> >Use emacs editor to change to new name of tblspace anyplace in file and then
> >import that file.
> >Correct me if I am wrong.
> >CH
>
>
> You are wrong. VERY wrong. You can't edit a dump file.
>

Hm. Formally speaking, you can't. Oracle doesn't support it. However, if done carefully, it's quite possible.

>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Mon Jun 02 2003 - 10:37:04 CDT