Oracle Database Discussions

Hi,

I am doing export with following command on 9.2 database on AIX. tablename
getting passed as parameter

exp / tables=test.$table file=$table.dmp log=export.log full=n

SQL> show user
USER is "OPS$test

SQL> select * from session_privs;

PRIVILEGE
----------------------------------------
CREATE SESSION
BACKUP ANY TABLE
SELECT ANY TABLE
SELECT ANY SEQUENCE
EXECUTE ANY PROCEDURE
ALTER ANY TRIGGER
ANALYZE ANY
EXECUTE ANY TYPE
ADMINISTER RESOURCE MANAGER

Now I am trying to importtable with test

SQL> select * from session_privs;

PRIVILEGE
----------------------------------------
CREATE SESSION
CREATE TABLE
CREATE SYNONYM
CREATE PUBLIC SYNONYM
DROP PUBLIC SYNONYM
CREATE VIEW
CREATE SEQUENCE
CREATE PROCEDURE
CREATE TRIGGER
CREATE ANY DIRECTORY

10 rows selected.

SQL> show user
USER is "TEST"

Now I am trying to import with following command after passing table parameter

imp test/test fromuser=/ touser=test tables=$table commit=yes file=$table.dmp

But I am getting following error

Export file created by EXPORT:V09.02.00 via conventional path
IMP-00013: only a DBA can import a file exported by another DBA
IMP-00000: Import terminated unsuccessfully

Kindly let me know where is error ( I belive in exp but not sure ) and secondly
how to correct it without changing privileges.

thanks & regards
pjp