Re: Import table into different tablespace

olCalvin Crumrine <Calvin_Crumrine_at_dced.state.ak.us> wrote in message news:<3C56D124.E0CB3C45_at_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.

The solution to your problem is posted almost every few weeks. You might be unwilling to search the archives, but please don't state nobody has come up with a solution. I won't repost it here now, I'm less and less inclined to post the same reply over and over again for people how are too lazy to search faq materials and the newsgroups archives. Please edit the export and good luck with it.

Regards

Sybrand Bakker
Senior Oracle DBA Received on Wed Jan 30 2002 - 06:01:17 CST