Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: COPY table with LOBs

Re: COPY table with LOBs

From: Mark Bole <makbo_at_pacbell.net>
Date: Wed, 12 May 2004 03:35:21 GMT
Message-ID: <ZXgoc.66329$T%2.57154@newssvr25.news.prodigy.com>


Dave Bender wrote:

> Great! That appears to do the trick.
>
> There is one oddity, though, at least to me. The table's owner is now the
> user from whom the table was copied. I did this:
>
> 1) User 'dev' granted select priveleges on 'table' to user 'test';
> 2) User test did the CTAS;
>
> The table was created and appears to have all the LOBs, however, a query of:
> SELECT table_name, owner from all_all_tables by user 'test' shows that
> the table is owned by user 'dev.'
>

[...]
>
>

Try DBA_TABLES instead of ALL_TABLES to be sure you're getting everything. Documentation available ("dictionary views") http://tahiti.oracle.com

--Mark Bole Received on Tue May 11 2004 - 22:35:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US