Re: ora-1950 on import

On May 15, 12:09 pm, StefanKapitza <skapi..._at_volcanomail.com> wrote:
> On May 15, 3:33 pm, Chuck <skilover_nos..._at_bluebottle.com> wrote:
>
> > What would cause this? I am exporting data from schema S1 in database
> > D1, and importing into schema S2 in database D2. In S1, everything is in
> > the USERS tablespace. I set up the default tablespace in S2 to be TS2,
> > grant unlimited quota on TS2 and no quota on USERS. S2 btw is starting
> > out empty. Out of 100 tables, 96 of them correctly loaded into
> > tablespace TS2, however on 4 of them I got ora-1950 - no privileges on
> > tablespace 'USERS'. Why?
>
> 4 Tables are different than the others (obvious answer).
>
> IIRC blobs or lobs or something like that are
> showing this behaviour, Solution is to create
> the Tables in advance with the desired tablespace and
> do an import with ignore=yes.
>
> regards.
>
> s.kapitza

Chuck, you should always include the full Oracle database version and explicitly name the utility being used (since there are two different Oracle import utilities) as well as include the version of the Oracle cleint when the import is not done on the database server.

There is as Stefan mentioned a bug where LOB tables will not pick up the importing touser default tablespace so if the LOB table tablespace does not exist the table fails to import. I cannot remember the error message. Stefan provided the solution in this case.

You should be able to use the show=y feature to extract the table DDL, pre-create the table, and do a tables= import to bring the data.

HTH -- Mark D Powell -- Received on Thu May 15 2008 - 11:29:01 CDT