RE: Moving Table with Long columns

From: Howard Latham <howard.latham_at_rsmb.co.uk>
Date: Thu, 16 Dec 2004 12:26:35 -0000
Message-ID: <8BA4F739A97DFB4D9A10D92A25A77F75211854@exchange-2003.rsmbdom2.local>

I am not sure if you could get away with using the COPY command - I.E. set up a loopback database link.

I seem to remember that working in Earlier Releases. - It would save you writing the data to disk.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Ganesh Raja Sent: 16 December 2004 11:56
To: Eric.Buddelmeijer_at_elegant.nl
Cc: pawan.dalmia_at_pharma.novartis.com; oracle-l_at_freelists.org Subject: Re: Moving Table with Long columns

Unfortunately ...

You cannot move a table containing a LONG or LONG RAW column.

What you can do is Do an export and Import for table with Long Columns or better still here is a Chance for you to move to Lobs ...

~
Ganesh

On Thu, 16 Dec 2004 12:14:00 +0100, Eric Buddelmeijer <Eric.Buddelmeijer_at_elegant.nl> wrote:
> Hi,

>=20
> I used below script to create sql to move tables containing CLOB's =
and
> BLOB's to another tablespace. I suspect it will work for LONG's as =
well,
> after some adaptation.

>=20

> Kind regards,
> Eric.

>=20

> select 'alter table '||table_name||' move tablespace <some new name>;'
> from dba_tables
> where tablespace_name =3D '<some old name>' order by table_name
>=20
> select 'alter table ' ||t.table_name||' move lob ('||c.column_name||') =
store
> as (tablespace <some new name>);'
> from dba_tab_columns c
> join dba_tables t on c.owner =3D t.owner and c.table_name =3D =
t.table_name
> where data_type like '%LOB%'
> and tablespace_name =3D '<some old name>'

>=20

> -----Oorspronkelijk bericht-----
> Van: oracle-l-bounce_at_freelists.org =

[mailto:oracle-l-bounce_at_freelists.org]
> Namens pawan.dalmia_at_pharma.novartis.com
> Verzonden: donderdag 16 december 2004 11:54
> Aan: oracle-l_at_freelists.org
> Onderwerp: Moving Table with Long columns

>=20

> Hi
> I want to move the table to different tablespace but table has long =
column
> how this thing can be done.

>=20

> Regards
> Pawan Dalmia
> Oracle DBA-Business Intelligence
> Desk-566
> Cell 9819718753

>=20

> --
> http://www.freelists.org/webpage/oracle-l

>=20

> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Dec 16 2004 - 06:30:58 CST