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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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,093 views