A few questions.

From: stevek <stefano1_at_att.net>
Date: Tue, 09 Apr 2002 12:44:09 GMT
Message-ID: <3CB2E173.2673E94@att.net>

Greetings,

I have a few questions perhaps someone can help me with. I am using Linux 6.2 and Oracle 8.1.6.

1. When I use comments in my sql scripts they produce 'Error at line 1: ORA-00900: Invalid SQL statement. I have tried REM(ARK), --, and /*  comment */. What am I doing wrong?

2. Are their system (shell) variables I can use that will tell Oracle to look in different locations for; passwd file, pfile, etc?

3. Academic question: why does Oracle use /app/oracle/8.1.6 in its OFA structure? Why not /8.1.6/ or 9.1.x/. What's the point of /app/oracle?

4. I moved all /u01/apps/oracle/8.1.6 binaries from on system to another. Ran create database scripts and during this process received the following msg's:
     ORA-00600: internal error code, arguments: [15456], [AQ$_SUBSCRIBERS], [13], [7], [tdo generation], [], [], []
ORA-21700: object does not exist or is marked for delete
ORA-06550: line 2, column 91:
PLS-00201: identifier 'SYS.AQ$_AGENT' must be declared
ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated
AS VARRAY(1024) OF sys.aq$_agent

and

ORA-04042: procedure, function, package, or package body does not exist
MGR-00072: Warning: PACKAGE BODY DBMS_AQ created with compilation errors.
MGR-00072: Warning: PACKAGE DBMS_AQADM created with compilation errors.
MGR-00072: Warning: PACKAGE DBMS_AQADM_SYS created with compilation errors.
Statement processed.
DROP PUBLIC SYNONYM dbms_aqadm

I guess the question is: must you install Oracle from scratch or is moving binaries good enough?

5. Under the bin directory there are many programs that have similar names with on having an O as it's last character. The file sizes are also different. Example: exp-338,849; expO-338,925. I can not find anything in the docs that explains this. Can someone help me out?

6. Is there a way to pause the 'desc' command. I have pause on during my sqlplus session, but desc always scrolls off my screen.

  Received on Tue Apr 09 2002 - 07:44:09 CDT