Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to remove ^M when open with vi

724798Jun 18 2010 — edited Jun 18 2010
Hi All,

O.S is SUN 5.10

below is .sh file which i need to run but when i opened it with vi it shows ^M, so how to remove this , please suggest.

ORACLE_SID=test^M
. oraenv^M
^M
sqlplus /nolog << EOF^M
conn / as sysdba^M
^M
set echo on^M
set heading off^M
set timing on^M
set serveroutput on^M
set timing on^M
^M
spool FUL_.SQL.OUT^M
^M
ALTER SESSION ENABLE RESUMABLE;^M
ALTER SESSION SET RESUMABLE_TIMEOUT = 10800;^M
alter session set current_schema=partd;^M
^M
@FUL_.SQL^M
ALTER SESSION DISABLE RESUMABLE;^M
spool off^M
EOF^M
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 16 2010
Added on Jun 18 2010
17 comments
2,173 views