import_db

no messages indeed.
so you go to sql*plus on the server and do
create user appadmin identified by appadmin;
grant connect to appadmin;

how can i grant dba_role to appadmin to ensure i have similar priviledges on account as 9i?

is OEM the only way to start the instances?

do i really need to read all of this to learn how to use OEM

http://download.oracle.com/docs/cd/B10501_01/em.920/a96670/toc.htm

It does not seem OEM is sinstalled as part of the server install. I looked for it and it is not there.
do i need to install the client package.

First of all, how did you do the export. Was it schema export or FULL export?

If you exported the schema only, then you will need to import using the FROMUSER and TOUSER parameters.

You will also need to create the user and tablespace for the data to reside befoe running import.

For a schema import try running

imp parfile=import.par

import.par --

USERID=appadmin/appadmin
BUFFER=5000000
FILE=9ifile.dmp
LOG=9ifile_imp_schema.log
COMMIT=Y
FROMUSER=<ENTER SOURCE SCHEMA USER HERE>                  - TOUSER=<ENTER DESTINATION SCHEMA USER HERE>

i did the export by schema. this is what i used.

exp appadmin/appadmin@myapp  file=myapp.dmp
imp appadmin/appadminfile=myapp.dmp  full=Y

Oracle told me that appadmin did not have right for the import since export was created by dba account.
I did it by system/manager. But i think i have to isse privieldges to appadmin on windows and then do the import. I will try FROMUSER like you said

Import using system or an account with import full database privillage.

You can then do a schema based import using FROMUSER / TOUSER.

Just make sure you have created the user prior to import.

this is what i get after i run your statement. a few errors related to tablespace and compile. I thought i had all tablespaces similar. do i need to redo it. how do you verify all objects aere imported and import did not stop in the middle.


IMP-00017: following statement failed with ORACLE error 959:
 "CREATE TABLE "TEMP_CLOB_TAB" ("RESULT" CLOB)  PCTFREE 10 PCTUSED 40 INITRAN"
 "S 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLE"
 "SPACE "USERDATA" LOGGING NOCOMPRESS LOB ("RESULT") STORE AS  (TABLESPACE "U"
 "SERDATA" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE  STORAGE(IN"
 "ITIAL 65536 FREELISTS 1 FREELIST GROUPS 1))"
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'USERDATA' does not exist


IMP-00017: following statement failed with ORACLE error 4098:
 "ALTER TABLE "REVIEW_ASSIGN" ENABLE CONSTRAINT "FK_REVIE_REFEREN"
 "CE_PICSUSER""
IMP-00003: ORACLE error 4098 encountered
ORA-04098: trigger 'APPADMIN.TRIG_AUDIT_DDL' is invalid and failed re-validation
IMP-00017: following statement failed with ORACLE error 4098:
 "ALTER TABLE "REVIEW_ASSIGN" ENABLE CONSTRAINT "FK_REV_REFERENCE"
 "_CSUSER""
IMP-00003: ORACLE error 4098 encountered
ORA-04098: trigger 'APPADMIN.TRIG_AUDIT_DDL' is invalid and failed re-validation
Import terminated successfully with warnings.

Have you created the tablespace USERDATA, the first error is saying it is unable to create the table as the tablespace does not exists.

I would drop the user with DROP USER <USER NAME> CASCADE;

Then reimport that data again.  Ensureing all tablespaces have been created first.

I did rename the tablespace from USERS to USERDATA.
I did the export from 9i using the appadmin account.
I did the import like you suggested using system account.

I see all tables getting imported fine and then a bunch of warnings on views
and then an audit DDL tigger/


If you compare the objects in 9i versus 11g they do not match. Does that mean import failed?
What do you suggest to do.


IMP-00041: Warning: object created with compilation warnings
 "CREATE FORCE VIEW "APPADMIN"."VW_MOVE_BOKS"                        



IMP-00017: following statement failed with ORACLE error 4098:
 "ALTER TABLE "QA_REVIEWER_ASSIGNMENT" ENABLE CONSTRAINT "FK_QA_REVIE_REFEREN"
 "CE_PICSUSER""
IMP-00003: ORACLE error 4098 encountered
ORA-04098: trigger 'APPADMIN.TRIG_AUDIT_DDL' is invalid and failed re-validation
IMP-00017: following statement failed with ORACLE error 4098:
 "ALTER TABLE "QA_REVIEWER_ASSIGNMENT" ENABLE CONSTRAINT "FK_QA_REV_REFERENCE"
 "_PICSUSER""
IMP-00003: ORACLE error 4098 encountered
ORA-04098: trigger 'ADDADMIN.TRIG_AUDIT_DDL' is invalid and failed re-validation
Import terminated successfully with warnings.

from the 9i database

OBJECT_TYPE          COUNT(*)
------------------ ----------
FUNCTION                   14
INDEX                     169
LOB                         9
PACKAGE                    24
PACKAGE BODY                8
PROCEDURE                  45
SEQUENCE                   54
SYNONYM                    37
TABLE                     225
TRIGGER                    43
VIEW                       43




in 11g after import

OBJECT_TYPE           COUNT(*)                                                  
------------------- ----------                                                  
INDEX                      200                                                  
INDEX PARTITION             50                                                  
LOB                         25                                                  
PACKAGE                      1                                                  
PACKAGE BODY                 1                                                  
PROCEDURE                    1                                                  
QUEUE                        4                                                  
SEQUENCE                    20                                                  
SYNONYM                      8                                                  
TABLE                      153                                                  
TABLE PARTITION             38                                                  

OBJECT_TYPE           COUNT(*)                                                  
------------------- ----------                                                  
TRIGGER                      2                                                  
TYPE                         1                                                  
VIEW                        12                                                  

14 rows selected.

I made a mistake in the above list for 11g list of objects. I was logged in as SYSTEM instead of APPADMIN. Here is the list as APPADMIN user it seems number of objects matches. you think everything was imported fine.

in 11g after import


OBJECT_TYPE           COUNT(*)                                                  
------------------- ----------                                                  
FUNCTION                    14                                                  
INDEX                      169                                                  
LOB                          9                                                  
PACKAGE                     24                                                  
PACKAGE BODY                 8                                                  
PROCEDURE                   45                                                  
SEQUENCE                    54                                                  
SYNONYM                     37                                                  
TABLE                      225                                                  
TRIGGER                     39                                                  
VIEW                        43