Export/Import tables

Hi all,

Can anyone help me to export and import the tables of a schema.

I am able to export using

exp username/passwd FILE=export.dmp TABLES=A1,A2 ROWS=yes CONSISTANCY=yes

But while importing it says only DBA can import the files exported by other DBAs ( IMP 00013:)

I am using : imp username/passwd FILE=export.dmp FULL=yes FROMUSER=username TOUSER=username

Thanks
Prabir Kishore

First... you posted your question in the wrong section of the forum.
Second... isn't the message clear enough? what part of "only DBA can import the files exported by other DBAs" requires translation?

Grant DBA privilege to the user importing your objects.
HTH

or re-run the export using a non dba user!