Home » Infrastructure » Unix » UNIX Commands for SQLPLUS utility (Unix - oracle 10.2.0.1.0)
UNIX Commands for SQLPLUS utility [message #490988] Fri, 28 January 2011 06:33 Go to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi All,

I am struggling to get UNIX commands for SQLPLUS environment,
please someone help me...

Regards:
Muktha
Re: UNIX Commands for SQLPLUS utility [message #490990 is a reply to message #490988] Fri, 28 January 2011 06:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> !date
Fri Jan 28 13:36:40 NFT 2011

Regards
Michel
Re: UNIX Commands for SQLPLUS utility [message #491039 is a reply to message #490988] Fri, 28 January 2011 09:35 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I am struggling to get UNIX commands for SQLPLUS environment,

it works for me.
bcm@bcm-laptop:~$ uname -a 
Linux bcm-laptop 2.6.32-28-generic #55-Ubuntu SMP Mon Jan 10 23:42:43 UTC 2011 x86_64 GNU/Linux
bcm@bcm-laptop:~$ sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Fri Jan 28 07:34:56 2011

Copyright (c) 1982, 2009, Oracle.  All rights reserved.



It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: UNIX Commands for SQLPLUS utility [message #491071 is a reply to message #491039] Fri, 28 January 2011 22:44 Go to previous messageGo to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi Michel\Blackswan,

I meant, i want to practice oracle DBA\PLSQL in unix's sqlplus window...
Eg - while creating tablespace, how to copy(Drag) the path for the datafile.....
please guide me

Regards:
Muktha
Re: UNIX Commands for SQLPLUS utility [message #491077 is a reply to message #491071] Fri, 28 January 2011 23:32 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Are you really asking how to copy and paste a string?
Re: UNIX Commands for SQLPLUS utility [message #491084 is a reply to message #491071] Sat, 29 January 2011 00:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please explain in details what you want to (maybe through an example), we are unable to understand your question.

Regards
Michel
Re: UNIX Commands for SQLPLUS utility [message #492319 is a reply to message #491084] Sat, 29 January 2011 06:15 Go to previous messageGo to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi Michel,

Yes,
1) How to copy the os path while specifying DATAFILE(can we drag the path).
2) I have one script file based on windows, how to run it in UNIX platform.

Thanks & Regards:
Muktha
Re: UNIX Commands for SQLPLUS utility [message #492330 is a reply to message #492319] Sat, 29 January 2011 09:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1) "Are you really asking how to copy and paste a string?"
2) a SQL script is platform independant (but for file names)

Regards
Michel
Re: UNIX Commands for SQLPLUS utility [message #492523 is a reply to message #492330] Mon, 31 January 2011 23:19 Go to previous messageGo to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi All,

Thanks for your reply,

1) CREATE SPFILE FROM PFILE =<path/filename.ora>
How to copy and past the path of the PFILE into SQLPLUS window in unix.
2) Also guide for running DBCA in UNIX.

Regards:
Muktha
Re: UNIX Commands for SQLPLUS utility [message #492532 is a reply to message #492523] Tue, 01 February 2011 01:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1) In the same way as usual
2) Type "dbca"

Regards
Michel
Re: UNIX Commands for SQLPLUS utility [message #492534 is a reply to message #492532] Tue, 01 February 2011 01:08 Go to previous messageGo to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi Michel,

Thanks for the reply,

please guide me on the below issues.
Questions:
1) Just typing DBCA is not allowing me to create a new database.
2) How to edit the SQLPLUS window, as we do in windows - ed (then notepad will open).

Regards:
Muktha
Re: UNIX Commands for SQLPLUS utility [message #492535 is a reply to message #492534] Tue, 01 February 2011 01:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1) Yes it does if you are in the OS dba group
2) This is meaningless

You have to use more words to explain what you are trying to do, no one is understanding you.

Regards
Michel

[Updated on: Tue, 01 February 2011 01:12]

Report message to a moderator

Re: UNIX Commands for SQLPLUS utility [message #492591 is a reply to message #492535] Tue, 01 February 2011 06:14 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>2) How to edit the SQLPLUS window, as we do in windows - ed (then notepad will open).
You need to define your editor.
No notepad in unix. All unix will have vi.
All can be configured for vim/emacs/pico.
http://download.oracle.com/docs/cd/B19306_01/server.102/b15658/admn_sqlpls.htm#sthref258

[Updated on: Tue, 01 February 2011 06:15]

Report message to a moderator

Re: UNIX Commands for SQLPLUS utility [message #493021 is a reply to message #492591] Fri, 04 February 2011 05:40 Go to previous messageGo to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi Mahesh,

Thanks for your reply

The command to get this is:
DEFINE_EDITOR=VI
Re: UNIX Commands for SQLPLUS utility [message #493093 is a reply to message #493021] Fri, 04 February 2011 15:16 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
muktha_22 wrote on Fri, 04 February 2011 06:40
Hi Mahesh,

Thanks for your reply

The command to get this is:
DEFINE_EDITOR=VI


Perhaps it actually is:
export EDITOR=vi #<- ksh/bash
EDITOR=vi; export EDITOR #<- sh

PS: To copy and paste a string in a unix window, it may depend on the terminal emulator you are using. Normally it would be to select the string using the cursor to copy and then right-click where you want to paste.

[Updated on: Fri, 11 February 2011 07:55] by Moderator

Report message to a moderator

Re: UNIX Commands for SQLPLUS utility [message #493099 is a reply to message #493093] Fri, 04 February 2011 17:12 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
EDITOR=vi; export EDITOR #<- sh/ksh/bash

Previous Topic: MAILX
Next Topic: Sun Solaris Unix Freeware && Oracle 10g for Single User
Goto Forum:
  


Current Time: Thu Mar 28 17:12:57 CDT 2024