Re: How to change object's tablespace ?

From: Chuck Hamilton <chuck_hamilton_at_yahoo.com>
Date: Mon, 24 Sep 2001 12:56:57 -0400
Message-ID: <9onokf$eeti8$1@ID-85580.news.dfncis.de>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I created a couple of 8.1.7 databases recently with the DB configuration assistant on NT, and it sets the compatible parameter to 8.0! That probably who your smart-ASSistant is. :-)

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:tquo8q3r1lo0c2_at_news.demon.nl...
>
>
> If you have 8.1.6 and the compatible init.ora parameter is set to
> an appropiate value
> (guys today I discovered I can't use any 8i feature in a 8.1.7
> database because some smart ass has set the compatible parameter to
> 8.*0*.5!!!!!, and there's really no need for that)
> you can simply issue a series of alter table move.
> In that case you can simply

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBO69l1mm5A4kkb4ZsEQL25ACeP116sqZ1XUgoifolZu7DNCmiPnMAoIR2 M1f9G3RYRyJyvrrj0wMe97Me
=fF07
-----END PGP SIGNATURE----- Received on Mon Sep 24 2001 - 11:56:57 CDT