| dbua is displaying a dbms_output.enable error [message #126420] |
Mon, 04 July 2005 07:31  |
james_briar
Messages: 39
Registered: April 2005
Location: Morden (South London)
|
Member |
|
|
Hello all, i'm doing a test upgrade of an Oracle8i (8.1.7.4) database to an Oracle9i (9.2.0.6) database using Migration Assistant. I'm running dbua& from the Unix command line. The Migration Assistant starts up ok and i select a database to be upgraded but i get a "DBMS_OUTPUT.ENABLE must be declared" error.
How do i fix this if i'm running dbua& from the Unix command line (i'm not logged into SQLPLUS to start with so i can't set dbms_output.enable?).
Thanks.
|
|
|
|
|
|
| Re: dbua is displaying a dbms_output.enable error [message #126443 is a reply to message #126420] |
Mon, 04 July 2005 09:33  |
james_briar
Messages: 39
Registered: April 2005
Location: Morden (South London)
|
Member |
|
|
Hello Frank, thanks for replying. I logged on as SYS and did describe DBMS_OUTPUT and it didn't exist. I ran the dbmsotpt.sql script (i saw that the catproc.sql script calls it). This fixed my problem, describe DBMS_OUTPUT displayed some output this time. I'm running dbua& and its now running fine.
Thanks again.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
