Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: COPY table with LOBs
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