Welcome to the COE Discussion Forum! 

 

To participate in the discussion forum, you must be logged in to the website.  If you forget your login information, please contact COE Headquarters at coe@coe.org or (800) 263-2255.

If you are new to the COE Discussion Forum and would like to participate, please register.


Register Today
COE 2009 Annual PLM Conference & TechniFair

COE DISCUSSION FORUM
Subject: Problem exporting (dump) smarteam database

You are not authorized to post a reply.   
Author Messages
purak

29 Feb 2008 08:47 AM
Hi,
     I am having problems exporting my smarteam database.

When I run the command

  exp  username/password@SID  full=y   file=my_filename.exp

I get the following errors

------
  Connected to: Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
 With the OLAP and Oracle Data Mining options
 JServer Release 9.2.0.3.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
 About to export specified users ...
 . exporting pre-schema procedural objects and actions
 . exporting foreign function library names for user SMARTEAM
 . exporting PUBLIC type synonyms
 . exporting private type synonyms
 . exporting object type definitions for user SMARTEAM
 EXP-00008: ORACLE error 942 encountered
 ORA-00942: table or view does not exist      
 EXP-00024: Export views not installed, please notify your DBA
 EXP-00000: Export terminated unsuccessfully  
------

Does anybody knows what could be the problem, and if at all it's possible
to get a dump of the database.

Many Thanks in advance

krish
bwfisher

08 Apr 2008 06:18 PM
Krish,

The message you received indicates it is a ORACLE error 942 for a table
or view that does not exist.

If there is a synonym on another table or view, and the user has select
privilege on the underlying table or view, but not the synonym, then he
cannot look up the synonym in the catalog.

I recommend researching the errors in the documentation on the Oracle
web site - http://www.oracle.com

The following is one issue that was noted.

DATABASE LINKS GENERATED WITH QUOTED LOWER LETTERS GIVES ORA-00942
(2720359)
If you update the database links module properties and set the user
and/or password in lower case or mix of lower and upper case, the
generated database link contains user and/or password in quoted lower or
mixed case, and may result in ORA-00942. Configuration of database links
(or registration of locations in releases after 9.0.4) will preserve the
case of the username and password entered by the user when database
links are generated. Therefore it is important to use the appropriate
case for the referenced object; i.e. uppercase for Oracle and mixed case
for some non-Oracle systems.


Barry Fisher
IBM PLM Technical Support Americas
purak

09 Apr 2008 03:33 AM

Barry,

         Many thanks for your reply. I managed to sort out the problem a few weeks ago,

and was meaning to post a followon to this thread about the solution.

Essentially,  I was told by my support people that when I created my

database, somehow, 'catalog.sql' was not run on the database. 'catalog.sql' should

have automatically been run at database creation time - I don't know why this didn't

happen.

Now I have run catalog.sql on my database/s and this seems to have fixed the problem.

 

To run 'catalog.sql' on the database, I have had to do a cold backup of the database

(just for precaution). Then rum the following command after login into thw database

in 'sqlplus'. (as sys user with sysdba).

The command to run is

 

@C:\oracle\ora92\rdbms\admin\catalog.sql

 

Thanks for the help again

 

Krish

You are not authorized to post a reply.
Forums > COE Forums > SmarTeam > Problem exporting (dump) smarteam database



ActiveForums 3.6

    

401 North Michigan Avenue, Chicago, IL 60611-4267 | (312) 321-5153 | (800) COE-CALL (U.S.)