RE: Moving Table with Long columns
- From: "Howard Latham" <howard.latham@xxxxxxxxxx>
- To: <ganesh.raja@xxxxxxxxx>, <Eric.Buddelmeijer@xxxxxxxxxx>
- Date: Thu, 16 Dec 2004 12:26:35 -0000
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Ganesh Raja
Sent: 16 December 2004 11:56
To: Eric.Buddelmeijer@xxxxxxxxxx
Cc: pawan.dalmia@xxxxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxx> 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@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> Namens pawan.dalmia@xxxxxxxxxxxxxxxxxxx
> Verzonden: donderdag 16 december 2004 11:54
> Aan: oracle-l@xxxxxxxxxxxxx
> 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
> --
> //www.freelists.org/webpage/oracle-l
>=20
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
