Home » RDBMS Server » Enterprise Manager » error messages displayed in schema manager
error messages displayed in schema manager [message #67814] Fri, 12 April 2002 08:09 Go to next message
M Hamilton
Messages: 2
Registered: April 2002
Junior Member
When an error occurs while trying to create a materialized view in schema manager, the error screen displayed does not show the error code or cause due to a lot of the code being displayed first, runs out of space on the screen. How can I see the rest of the error message? There is no scroll bar. Is a temp file created somewhere?

Report message to a moderator

Re: error messages displayed in schema manager [message #67815 is a reply to message #67814] Fri, 12 April 2002 08:23 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
Copy the create statement to a file and run it from sqlplus.

SQL> set echo on
SQL> spool create_mv.log
SQL> @create_mv.sql
SQL> show error
SQL> spool off

You might find something in DBA_ERRORS.

Report message to a moderator

Previous Topic: Re: log-on on OEM as SYSDBA
Next Topic: How To Start oem in Linux 7.2 of Oracle 8.1.6
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 18:36:13 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.