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

Home -> Community -> Usenet -> c.d.o.misc -> V9.2 Import with LOBs

V9.2 Import with LOBs

From: TurkBear <john.greco_at_dot.state.mn.us>
Date: Tue, 11 Mar 2003 09:18:00 -0600
Message-ID: <alur6vcmek6re850thfleo8ue3nu2jsl9g@4ax.com>


Hi,
Is there something 'special' about importing tables with LOBs ( both CLOB and BLOB) when using the FROMUSER and TOUSER parameters -
Importing as SYSDBA.
The TOUSER gets al the tables except the ones with LOBs and on those we get a 'Insufficient Privileges' error on the tablespace that the exported tables were in ( the same as the other tables that import OK; the TOUSER account does not have permission to use that tablespace so the tables go into his default tablespace , except for these)

Oracle 9.2
Windows W2K

( same for exported and Imported data - just different schemas )

Thanks, Received on Tue Mar 11 2003 - 09:18:00 CST

Original text of this message

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