181 Responses to “Step by Step Oracle guides” tejas patel Says: December 8th, 2009 at 12:31 pm. My goal is made a oracle DBA.so please help me. Database design, database application development, training, and Oracle database administration. Addition to authoring several certification study guides for Oracle 10g and Oracle 11g. McGraw-Hill and its licensors do not warrant or guarantee that the functions contained in the work will meet your. 2006 State Of The Business Incubation Industry Pdf Files.

As far as i can see the screenshot, it suggests that username or role services and administrator are not present. Check in dba_roles and dba_users for these usernames or roles, if you are not importing the full database then the usernames and roles will not get imported, you have to create them manually and retry the import then it will complete without any errors. Check in the database from where the export has taken, and create the username/role for services and administrator, and retry the import you should not receive any errors/warnings this time. Ok, I checked the log and it appears that services and administrator are not being created because I've got a temporary tablespace setup for them in the source database and there is a problem when that tablespace is imported into 11g.

I've attached the log, but here is an excerpt from it. IMP-00017: following statement failed with ORACLE error 10615: 'CREATE USER 'ADMINISTRATOR' IDENTIFIED BY VALUES '0E7353571C749B0F' DEFAULT' ' TABLESPACE 'USER_DATA' TEMPORARY TABLESPACE 'TEMPORARY_DATA' IMP-00003: ORACLE error 10615 encountered ORA-10615: Invalid tablespace type for temporary tablespace When I view my tablespaces I'm noticing that I have a temporary tablespace named temp and my temporary_data but the temporary_data is set to permanent. Should this be temporary and how do I change it?

You can create the user in a different tablespace and re-run the import as the problem which you have encountered is about the grants, where in the grant was not succeeded as user was not there. Psremote 2 5 1 Keygen Photoshop.