Re: CTXSYS schema

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Fri, 19 Aug 2005 14:18:16 +0200
Message-ID: <4305cf36$0$24147$9b4e6d93@newsread4.arcor-online.net>

Frank van Bortel schrieb:
> Fabrizio wrote:
>

>>chloe.crowder_at_bl.uk wrote:
>>
>>By the way: LOB can be exported/imported.
>>I export the CTXSYS schema every night even on my old 8.1.7.4...
>>

>
> Yes - but cannot be moved. So her boss is only partially right.
> Marginally, I'd say - but it's better to admit he was right (a bit) ;)
>

Are you sure, you are speaking about LOB's, not LONG's ?

jones_at_ORA92> create table test_lob(id number,text clob) tablespace users lob(tex
t) store as(tablespace users)

2 /

Table created.

jones_at_ORA92> select segment_name,segment_type,tablespace_name from user_segments
;

SEGMENT_NAME                   SEGMENT_TYPE       TABLESPACE_NAME
------------------------------ ------------------ ---------------
TEST_LOB                       TABLE              USERS
SYS_IL0000028044C00002$$       LOBINDEX           USERS
SYS_LOB0000028044C00002$$      LOBSEGMENT         USERS

jones_at_ORA92> alter table test_lob move tablespace tools lob(text) store as(table
space tools);

Table altered.

jones_at_ORA92> select segment_name,segment_type,tablespace_name from user_segments
;

SEGMENT_NAME                   SEGMENT_TYPE       TABLESPACE_NAME
------------------------------ ------------------ ---------------
TEST_LOB                       TABLE              TOOLS
SYS_IL0000028044C00002$$       LOBINDEX           TOOLS
SYS_LOB0000028044C00002$$      LOBSEGMENT         TOOLS

jones_at_ORA92>

Best regards

Maxim Received on Fri Aug 19 2005 - 07:18:16 CDT