Oracle Database Discussions

Hello, Quite new to Oracle here..

Oracle 9.2.0.6 on hp UX 11i.

I have an .exp file containing users, schemas and everything. Its a normal exp.

Here is what I do.

1- I create an empty database called VPMTEST
2- I set the Oracle_SID to VPMTEST

I log on Sqplus, and i create some users that i know are in the .exp file by doing this:
SQL>create user usernameidentified by password;
SQL>grant resource, connect, dba to username;
SQL> commit;
SQL> exit

# imp
Username: system
Password: password
ImportFile: my_file.exp
Enter Buffer Size (min is 8192) 30720> 30720
Export file created by EXPORTLV09.02.00 via conventional patch
import done in US7ASCII character set and AL16UTF16 NCHAR character set
impoer server uses WE8IS08859P1 character set (possible charset convertion)

List contents of import file only (yes/no): no > yes
Import Entire export file? (tes/no) no:> no (i do not know the sys/system passwords on the .exp)
Username: username (not a dba)
Enter table(T) or partition(T:P) names. Null list means all tables for user
Enter table(T) or partition(T:P) name or . if done: [ENTER] (i do not know the tables)
=============================================================

Once the import is done, i have the import sucessful without warnings.
The next step, i verify if everything was imported correctly by doing this:

sqlplus :sys/passwd as sysdba"
SQL> describe username
ERROR:
ORA-0403: object username does not exist

SQL>,


Anybody have an idea of what my problem could be???
Thanks a lot for reading

Maxime.

null

Message was edited by:
malarie

Message was edited by:
malarie