asked on error on rebuild indexes script
Hello,
When I execute with following scripts, I have this error :
SQL> SQL> SQL> SQL> SP2-0042: unknown command "SQL>" - rest of line ignored.
SP2-0734: unknown command beginning "SQL> SELEC..." - rest of line ignored.
How can I resolve it?
Thanks
When I execute with following scripts, I have this error :
SQL> SQL> SQL> SQL> SP2-0042: unknown command "SQL>" - rest of line ignored.
SP2-0734: unknown command beginning "SQL> SELEC..." - rest of line ignored.
export SID=$1
export SCHEMA=$2
export ANA_LOG=/opt/oracle/logs
export ANA_SQL=/opt/oracle/scripts
export HOME=/home/oracle
. ${HOME}/.bash_profile
if [ -f ${ANA_LOG}/rebuild_index_$1_$2.log ] ; then
rm ${ANA_LOG}/rebuild_index_$1_$2.log
fi
logf=${ANA_LOG}/rebuild_index_$1_$2.log
date >${logf}
export ORACLE_SID=${SID}
sqlplus /nolog << EOF >>${logf}
connect / as sysdba
set feedback off
set pagesize 0
SPOOL /opt/oracle/scripts/Indexrebuild_${ORACLE_SID}_${SCHEMA}.SQL
SELECT 'ALTER INDEX '||OWNER||'.'||SEGMENT_NAME||' REBUILD TABLESPACE '||TABLESPACE_NAME||';' FROM DBA_SEGMENTS
WHERE OWNER='${SCHEMA}' AND SEGMENT_TYPE='INDEX';
SPOOL OFF
@/opt/oracle/scripts/Indexrebuild_${ORACLE_SID}_${SCHEMA}.SQL
EOF
date >>${logf}
exit;
How can I resolve it?
Thanks
Oracle Database
Last Comment
johnsone
ASKER
I modified the settings like :
set feedback off
set pagesize 0
set echo off
set lines 32767
set trimspool on
The following error occurs:
SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 2 SQL> SQL> SQL> SQL> SP2-0042: unknown command "SQL>" - rest of line ignored.
SP2-0734: unknown command beginning "SQL> SELEC..." - rest of line ignored.
SP2-0042: unknown command "SQL>" - rest of line ignored.
SP2-0734: unknown command beginning "SQL> SPOOL..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Sun Dec 29 15:53:41 CET 2013
SQL> SQL> SQL> SQL> SP2-0042: unknown command "SQL>" - rest of line ignored.
SP2-0734: unknown command beginning "SQL> SELEC..." - rest of line ignored.
set feedback off
set pagesize 0
set echo off
set lines 32767
set trimspool on
The following error occurs:
SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 2 SQL> SQL> SQL> SQL> SP2-0042: unknown command "SQL>" - rest of line ignored.
SP2-0734: unknown command beginning "SQL> SELEC..." - rest of line ignored.
SP2-0042: unknown command "SQL>" - rest of line ignored.
SP2-0734: unknown command beginning "SQL> SPOOL..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Sun Dec 29 15:53:41 CET 2013
SQL> SQL> SQL> SQL> SP2-0042: unknown command "SQL>" - rest of line ignored.
SP2-0734: unknown command beginning "SQL> SELEC..." - rest of line ignored.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
You should add at least these to your settings:
set echo off
set lines 32767
set trimspool on
That should get you closer.
I believe that your resulting script is actually working, those errors are just extraneous messages.
If you could post at least the first few lines of the SQL file, through the first couple of alter statements, then we could help more. Please make the suggested changes first.