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
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.
or re-run the export using a non dba user!