Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 7:moving tablespaces

Re: Oracle 7:moving tablespaces

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Mon, 02 Jun 2003 19:06:47 +0200
Message-ID: <iv0ndv4b99m8d9d8rscuhntmk7d44f2cjv@4ax.com>


On 2 Jun 2003 08:37:04 -0700, afilonov_at_yahoo.com (Alex Filonov) wrote:

>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

And it should be considered quite dangerous and quite stupid, as far as I'm concerned.
But you might be more of a hacker.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Jun 02 2003 - 12:06:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US