| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Import table in Different Tablespace
On Thu, 21 Oct 1999 09:58:28 GMT, postbus_at_sybrandb.demon.nl (Sybrand
Bakker) wrote:
>Obviously that user has the resource role, right?!
>Then he has unlimited tablespace privilege. As the orginal tablespace
>is in the create table statement in your dump, they will end up in the
>same tablespace. Additional to changing the default tablespace, you
>need to
>revoke unlimited tablespace from <youruser>;
>
>Then you need to
>
>alter user <youruser> quota unlimited on <new tablespace>;
>
>Now the table import will go OK,
Unfortunately this will not work OK, the tables will still end up in their original tablespace, because the most important part is missing (and the first part with removing unlimited tablespace privilege is not really relevant here): you have to revoke any quota on the original tablespace from your user.
ALTER USER <youruser> QUOTA 0 ON <original_tablespace>;
Now the tables will end up in user's default tablespace.
> indexes will still end up in the
>wrong tablespace.
>Import with indexes=N, do a second import with indexfile=<somefile>
>This will generate a create index script. Edit the script and run it.
>You should be all set now.
>
>Hth,
>
>Sybrand Bakker, Oracle DBA
HTH,
Jurij Modic <jmodic_at_src.si>
Certified Oracle DBA (7.3 & 8.0 OCP)
 |
 |