Title: rman oddities
Hi,
I have
seen some responses and discussions about 'orphaned' backups regarding RMAN
after a recovery has been done. I would like to attempt to clarify why
"old" backups being registered in the catalog are important, and very useful in
a given situation for
Hello List,
I need to pass several arguments to a dos batch program which is being
called from sqlpus through HOST command.
Example: host mybatch.bat myargument myargument
Would such idea work?
Thank you.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET:
Hi
,
OAS -
Oracle application server .
satish
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of RiswandiSent: Tuesday,
December 04, 2001 6:30 AMTo: Multiple recipients of list
ORACLE-LSubject: What is OAS ?
Hi all,
What is OAS ?
Hopefully there will be an end to the java hype, the buggy, slow, java-fied
installers, etc...
--Scott
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, December 03, 2001 5:30 PM
Why???
-Original Message-
Sent: Monday, December
Hi,
I now have extra disks so I am re-arranging our databases. We will also be
renaming the mount points (obviously the db's are on UNIX - HP-UX).
I just want to confirm the steps I would have to do for this:
1. Make a cold backup
2. Move Controlfiles:
(i) copy existing cf's to new
-- Scott Shafer [EMAIL PROTECTED]
Haven't heard myself, but I hope this is true. Please, please, please
let it be true!
Unlikely they'll actually dump java. If Oracle would simply
SUPPORT DBI it'd be worth something...
--
Steven Lembark 2930 W. Palmer
I have to concur. I run a small backup utility for an Oracle / Sun box via my browser
every morning, and it takes ages to load. This is on a brand new network. And yes,
it's a buggy, fussy piece of software. I hate to say this, but even something written
in VB would be faster and far more
-- David McVeigh [EMAIL PROTECTED]
I have to concur. I run a small backup utility for an Oracle / Sun box
via my browser every morning, and it takes ages to load. This is on a
brand new network. And yes, it's a buggy, fussy piece of software. I hate
to say this, but even something written
Hello all,
Why cannot I do :-
sqlplus -s scott/tiger select * from emp;
or sqlplus -s scott/tiger select * from emp;
Both the cases I get :-
Usage: SQLPLUS [option] [user[/password] [@host]]
[@startfile [parm1] [parm2] ...]
where option ::= { -s | -? }
You can't have the SQL statements on the command line. You must put them
in
a script file (eg myscript.sql) and execute it with the @ sign.
Thus,
sqlplus -s scott/tiger @myscript[note the SPACE between the tiger and
the @].
Hemant
Viraj Luthra [EMAIL PROTECTED] 04/12/2001 01:10 PM
You forgot to say it is obsolete. :)
Jared
On Monday 03 December 2001 19:35, satish p wrote:
Hi ,
OAS - Oracle application server .
satish
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Riswandi
Sent: Tuesday, December 04, 2001 6:30 AM
I don't believe SQLPlus will let you run a SQL statement in the command line
itself. As you can see in Usage:, it doesn't have an option for this.
However, if you insist on running SQL statements in the command line itself,
you can probably do something like (only in Unix):
sqlplus -s
DBI is your friend :-) Now that they've combined svrmgrl
into the sqlplus engine there isn't anything you can't
do through DBD::Oracle (or the shell if really necessary).
Yeah, this has some very cool implications. It would be possible
to start and stop your databases remotely via
Is there a way to defer the application of archive logs in the Standby db?
Or maybe defer the actual sending of the logs from the Primary db. Kind of
like the INTERVAL option in SCHEDULE_PUSH of Adv. Replication.
Thanks,
Ross
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
I think they do. Isn't it included now in the 9i version of iAS ?
Jared
On Monday 03 December 2001 20:25, Steven Lembark wrote:
-- Scott Shafer [EMAIL PROTECTED]
Haven't heard myself, but I hope this is true. Please, please, please
let it be true!
Unlikely they'll actually dump java.
The way you're doing it sqlplus is trying to parse the SQL
as a command line argument, which will not work.
Try these:
1.
echo select * from dual; | sqlplus scott/tiger
2.
sqlplus scott/tiger EOF
select * from dual;
EOF
Jared
On Monday 03 December 2001 21:10, Viraj Luthra wrote:
Hello
A couple of questions for two alternative scenarios we are looking at :
1. One iAS f or Two Portal DBs with the same initial URL
OR
2. Two iAS installs for two Portal DBs with the same initial URL
Jared,
Using the 2nd option:-
sqlplus system/manager@orcl815 !
SELECT a.username, substr(sql_text,1,100), substr(sql_text,101,250),
substr(sql_text,601,250),substr(sql_text,851,250),
substr(sql_text,1101,250)
FROM sys.dba_users a, v$session, v$sqlarea
where parsing_user_id=user_id AND
try this
$ echo select * from emp; | sqlplus scott/tiger
srinivas
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 04, 2001 2:31 AM
To: Multiple recipients of list ORACLE-L
You can't have the SQL statements on the command line. You must put
them
in
a script
Title: RE: simple sql problem
Hi...
You cann't run sql statement in command line directly However you can in case of script file.
Make the query as a script file. Then run it on SQLPLUS.
-- c:\test.sql
-
select * from emp
/
exit
/
gee what is ping? oh yeah maybe thomas needs to know
that;)
its been a long day .. dont mind !!!
--- Mercadante, Thomas F [EMAIL PROTECTED]
wrote:
Gee, how do I unsubscribe? Oh-yeah! Its at the
bottom of every piece of
mail!!!
Holy Cow BatMan!
To REMOVE yourself from this mailing
-- Jared Still [EMAIL PROTECTED]
Unlikely they'll actually dump java. If Oracle would simply
SUPPORT DBI it'd be worth something...
I think they do. Isn't it included now in the 9i version of iAS ?
It is there. What I don't know is how well supporte it is.
Say you call up with a question
-- Jared Still [EMAIL PROTECTED]
DBI is your friend :-) Now that they've combined svrmgrl
into the sqlplus engine there isn't anything you can't
do through DBD::Oracle (or the shell if really necessary).
Yeah, this has some very cool implications. It would be possible
to start and stop
Hallo,
Can anybody tell me simply how the listener works?
Thanks in advance
Roland S
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California--
Title: RE: how to pass argument to a dos batch program from sqlplus
Have you been tried for it?
It'll work fine.
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, December 04, 2001 5:25 AM
To: Multiple recipients of list ORACLE-L
Subject: how
Well,
you can runt the sqllodader again and then include this line after the name ofthe
control file.
log = C:\temp\error.log
and that creates a logfile where you can see what has happened. The problem you are
having can be caused
by invalid length of the datafield in the database, or you
101 - 126 of 126 matches
Mail list logo