Re: Import/Export Question.

[Quoted] [Quoted] The problem is not the dba role but the resource role, which implies unlimited tablespace privilige.
[Quoted] Try to revoke unlimited tablespace privilege and make sure the default [Quoted] tablespace is not SYSTEM and it should work. The alternative is running imp show=y log=<any filename> this will dump all create statement to <any filename>.

Hth,

Sybrand Bakker, Oracle DBA

Alan <alan_psb_at_yahoo.com> wrote in message news:38DE957F.CC6B7417_at_yahoo.com...
> Hello all,
>
> I have a question related with Imp/Exp. I want to move all the
> tables from one database A to B (by Entire Database). User SYS_DBA1 on
> database A have DBA role and he exports entire database. However, on
> database A, some tables (data tables, owned by SYS_DBA1) are on
> tablespace SYSTEM.
>
> User SYS_DBA1 created in database B. Since I don't want to create
> the tables in tablespace SYSTEM, I revoke DBA role from SYS_DBA1 and
> issue "alter user SYS_DBA1 quota 0 on system" in database B. I import
> the file by user SYSTEM. However, I found that those tables on
> tablespace SYSTEM on database A are still imported into tablespace
> SYSTEM on database B.
>
> Is there any way such that I can import the tables (in tablespace
> SYSTEM, database A) to another tablespace (such as DATA1) in database B?
> The exported file are exported by user SYS_DBA1 (via entire database)
> and he has the DBA role. (I cannot create the export file again since
> the database has been removed!)
>
>
> Thanks,
> Alan
>
>
>
Received on Sun Mar 26 2000 - 22:29:07 CEST