Re: mapping devices on sqlplus! - Oracle 10g XE
- From: Stefan Knecht <knecht.stefan@xxxxxxxxx>
- To: grlongo.ireland@xxxxxxxxx
- Date: Sat, 23 Oct 2010 21:38:24 +0200
Try this:
oracle@central:~/temp/ [M2] cat > real_script.sql
select * from v$instance;
oracle@central:~/temp/ [M2] ln -s real_script.sql F:TESTfoo.sql
oracle@central:~/temp/ [M2] sqh
SQL*Plus: Release 11.2.0.1.0 Production on Sat Oct 23 21:36:43 2010
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL> @F:\TEST\foo.sql
INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE
LOG_SWITCH_WAIT
----------------- --------- ------------ --- ---------- -------
---------------
LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO
---------- --- ----------------- ------------------ --------- ---
1 M2
central
11.2.0.1.0 21-SEP-10 OPEN NO 1 STARTED
ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NO
Stefan
=========================
Stefan P Knecht
CEO & Founder
s@xxxxxxxx
10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland
Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info@xxxxxxxx
http://www.10046.ch
=========================
On Sat, Oct 23, 2010 at 11:44 AM, Guilherme Raymo Longo <
grlongo.ireland@xxxxxxxxx> wrote:
> Good morning....
>
> I trying to accomplish a task that is killing me... seriously!
> I am trying to adapt an application that runs on windows to work on an
> Ubuntu Server box.
> The thing is that during the installation at certain point it
> is necessary that some sql script gets opened and executed by sqlplus.
> I am doing everything I can with wine but after the sqlplus is opened the
> problem begins. This is the line that the executable runs to open the sql
> script:
>
> C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\BIN\SQLPLUS.EXE /NOLOG
> @F:\INTEGRADO\LINNER\SETUP\ARQUIVOS\USUARIOS.SQL
>
> The sqlplus file has been mapped correctly, but this
> path: @F:\INTEGRADO\LINNER\SETUP\ARQUIVOS\USUARIOS.SQL cannot be found
> because sqlplus does not have F:
> mapped. Wine does!
>
> So, my question is:
> Is there any way to map (by using environment variables or by any other
> way) a path to a device for example F: -> /my/path so sqlplus is able to
> find files when a statement like the one above is executed?
>
> Thanks in advance!
> Guilherme Longo
>
>
>
>
>
Other related posts:
