To Export Table on Oracle
=========================


> i'm exporting tables from one database (which are owned by the SYS user)
> into another database, to be owned by a user that i created.  below are
> the two commands i used, followed by the error message:
> 
> to export:
> 
> % exp SYS/<pword> file=exp.dmp tables="table1, table2"
> 
> and to import:
> 
> % imp user/password file=exp.dmp tables="table1, table2"
> 
> IMP-00013: only a DBA can import a file exported by another DBA
> 
> does anyone know how i can export a SYS-owned table and then import it
> into another database so that it's owned by a non-DBA user?
> incidentally, the user that i created has BECOME USER and BACKUP ANY
> TABLE privileges, i don't know if these are required.
> 
> any help will be appreciated,
> Maurice

Hi Maurice,

As you exported the original tables with a user being DBA you need
to import also with a user being DBA.

To import to another schema you can use the FROMUSER - TOUSER clause 
e.g.  imp sys/password file=exp.dmp tables="table1, table2" fromuser=sys
touser=newuser