Re: Import table into different tablespace

From: Calvin Crumrine <Calvin_Crumrine_at_dced.state.ak.us>
Date: Tue, 29 Jan 2002 07:43:17 -0900
Message-ID: <3C56D124.E0CB3C45@dced.state.ak.us>

Sybrand Bakker wrote:

> On 29 Jan 2002 01:39:43 +0100, Dirk Gomez <usenet_at_dirkgomez.de> wrote:
>
> >A lot of people might be unhappy with this solution, but this little perl
> >script has always helped:
> >
> >perl -pi.bak -e 's/OLDSTRING/NEWSTRING/g' <filename>
> >
> >where OLDSTRING and NEWSTRING will be something like <TABLESPACE \"BLABLA\">.
>
> THOU SHALLST NOT EDIT THE EXPORT FILE
> (nor promote it or assume financial responsibility for any havoc your
> advice causes)
>
> Regards
>
> Sybrand Bakker, Senior Oracle DBA

I'd already thought of (and rejected, except as a last resort) editing the export file. But so far nobody's come up with any other solution. Received on Tue Jan 29 2002 - 10:43:17 CST