Troubleshooting on the exception is some how difficult, it the package is
about 1000 lines and there are alot of block including nested block contend
with it own exception handle , how should we know which one of the exception
hit ???
I'm using TOAD , but browsing it in and out really made me
Dear DBA Gurus,
I want to create a stored procedure in which a name is passed as
input parameter. The procedure should take the name as input parameter and
create a user with the username and password same as name. Then I want to
connect as the newly created user and create a set of
I enabled all auditing on a table. After doing a select, insert and delete I have
one row in dba_audit_object which shows the following for ses_actions column:
---S--S--S--
I know that I have to tie this up with audit options in dba_obj_audit_options to get a
more readable report like :
I want to audit ALL objects in the database - we have a lot of objects lying around
and even the developers dont know whether some of them are being used or not.
I dont think there is any way by which I can audit all objects in the database (thats
by issuing a single stmt).
I tried to audit by
Unal
NOTE - sgadef$ORACLE_SID.dbf Files Existed in $ORACLE_HOME/dbs Dir
Upon Receipt of This Error Database is Already Up . Shut it Down First
we MOVED the sgadef$ORACLE_SID.dbf Files to a Temporary SUB-Dir under
$ORACLE_HOME/dbs Dir
Upon RE-Initiating the Oracle Installation We Still GOT
Hi,
AFAIK you can drop the temp tablespace after the restore and simply
recreate them.
I do this with COLD backups where I clone without copying the temp files
across the network. On startup it will complain that the datafiles aren't
there, after which you can drop the tablespace.
Jack
I want to create a stored procedure in which a name
is passed as
input parameter. The procedure should take the name as input
parameter and
create a user with the username and password same as name.
Then I want to
connect as the newly created user and create a set of tables.
You can't, but you can use 'alter session set
current_schema = ...'. Similarly, if the procedure
you're building has all the power the create users/
create tables, then it will be able to put data in
that table, it can also be used to temporary create a
secondary procedure in the new schema to
Common methods include setting a flag to indicate
process state..
eg
begin
...
...
...
some_flag := 'Up to here';
...
...
...
some_flag := 'Now here'
...
...
exception when no_data_found then
if some_flag = ... then
else
etc
end;
hth
connor
--- Raymond Lee Meng
Hi,
Not really an answer to your Q, but if the procedure is created by a user
with create any table privileges you can create tables in another schema
right?
So simply create your user and then create the tables in that new users
schema, no need to connect as that user.
Jack
Hallo you DBAs
Is it possible to use a view when you do a select statement in a dynamic sql-query in
a PL/SQL code?
Roland Sköldblom
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX:
Hallo all you DBA gurus,
Is it possible to get a more fast procedur running, by creating views of tables(many
tables involved) instead of querying directly on the tables.?
Roland Sköldblom
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Thanks chief. I'll keep an eye out for
any outer joins misbehaving.
Cheers
Nuno Souto
[EMAIL PROTECTED]
http://www.users.bigpond.net.au/the_Den
- Original Message -
_PUSH_JOIN_PREDICATE is set to TRUE or the accessing query contains
the
PUSH_PRED hint.
--
Please see the official
There is also one called The Big Picture - from Bit by Bit
www.bitbybit.co.uk - that scans all source, and SQL, and stores all
execution plans in a BDE database. It then scans through all the exectution
plans to determine whether an index is used or not.
It doesn't however tell you how many
Check Documentation for Materialized Views
HTH,
Rajesh
-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, May 29, 2001 1:26 PM
To: Multiple recipients of list ORACLE-L
Hallo all you DBA gurus,
Is it possible to get a more fast procedur running, by creating views
of
...
Venkata Ramana
Sierra Optima Limited,
SVR Towers, 8-2-1/B/1, Panjagutta,
Hyderabad 500082, India.
Ph: (91-40) - 3730321, 3746122, 3745051 Ext: 228,219
Fax:(91-40) - 3746419.
Email : [EMAIL PROTECTED]
--
From: Venkata Ramana Kanchinadam
Reply To: [EMAIL PROTECTED]
Hi Bruce
Yep there is something on Metalink about this when server uptime is 248
days
(I know it sounds unbelievable).
Happened to me, databases slowing/hanging and I could only shutdown abort
databases.
Rebooted and everything worked fine.
HTH
Mark.
Dear DBA Gurus,
I am able to execute the below code as an anonymous Pl/Sql block but when I
incorporate it in a stored procedure the procedure gets created but I am
getting the below errors while executing the procedure as system user:
Anonymous Pl/Sql block
Declare
name varchar2(4):='test';
Title: RE: Creating a sorted table
Hi
infact creating the table as sorted data from another table works with oracle 8.1.6.3.0 as:
create table agrs
as select * from agreements
order by agr_agreement_number desc;
Is this OK??
Vijay
--
From: Connor McDonald[SMTP:[EMAIL
Using views instead of tables directly will not have any performance gain.
Views should not be measured with table for performance as they are meant
for a different purpose. If you can use tables, use it. If you want to hide
coding complexity, customise data, check on user access etc., evaluate
Hi
I had these problems with the RMAN 8.0.5 that the backupsets were created
with status 'DELETED' in the recovery catalog. I want to clear the control
file records and the recreate the recovery catalog.
Is there a way to clear the backup information from control file without
recreating it.
Any
similarly you can issue 'alter tablespace temp add
datafile ... reuse'
connor
--- [EMAIL PROTECTED] wrote:
Hi,
AFAIK you can drop the temp tablespace after the
restore and simply
recreate them.
I do this with COLD backups where I clone without
copying the temp files
across the
Hallo you DBAs;
How can I make a query run faster, I have some queries and they tend to be be very
slow.
Roland Sköldblom
--
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
Dear DBA Gurus,
I solved the problem by incorporating the authid current_user clause. I
didn't explicitly grant any roles or privileges to system user. The
modified code is as
below:
create or replace procedure create_user (name IN VARCHAR2)
authid current_user
IS
BEGIN
EXECUTE IMMEDIATE
I always use a shutdown abort to clean up oracle sga files and processes.
[EMAIL PROTECTED] 05/29/01 04:10AM
Unal
NOTE - sgadef$ORACLE_SID.dbf Files Existed in $ORACLE_HOME/dbs Dir
Upon Receipt of This Error Database is Already Up . Shut it Down First
we MOVED the sgadef$ORACLE_SID.dbf Files
Oh No, Oh No - Be nice now ... (I can see all the 'undocumented' parameters
being hauled out again ...)
(Roland, that is a bit like asking 'How do I implement world peace?' or 'How
do I understand women?' - we can't help make a query run faster per se - a
little detail would be nice - like
Chase it with a big stick
Nah just kidding
Provide some more detail like version and what you are trying to actually
do and you are going to get a better answer.
As I always understood it, to get the best performance all other things
being correct with the system is that you have to make
Hi Everybody,
In D2k Report2.5 in the parameter form two user parameters are there with
list of values, based on the first parameter value, we need to generate 2nd
parameter's list of value.
For example
First Parameter field for Company code (it will give all list company code)
1- 100
In the 2nd
Why would you want to use a subquery? I can see no reason or it and
they do tend to slow things down.
Dick Goulet
-- Reply Separator --
Author: [EMAIL PROTECTED]
Date: 5/29/01 4:15 AM
Hallo you DBAs
How can I write this sql query using subqueries?
Title: ORACLE 8i DBA
hi
I am planning to take ORACLE 8i DBA Examination, Can you guys please guide w.r.t
1) Good Book to Refer
2) Steps to Prepare for all the 5 Papers
3) Cramsessions
4) Free downloadable Power Point Presentations
If you feel some more which i need to gear up with.
List, (win95, PO 803)
i posted this problem earlier also...and i have some more tracing to
share...
here's the situation...
i installed 16bit oracle executables, plus31 under home c:\orawin on win95
I CAN connect to all my DB's (on AIX machine) using plus31 without any
problems...
then i
Hi there everyone
Can somebody help me out. I am a newbie in Oracle and would like to
recall (recover) archive logs from the tape. (Using rman by SQLPLUS, I
am not clear as to what SQLPLUS command is used to recall arcbive logs
from tape, which are more than 6 months.).
Please help me out, I
Hi All,
A cheaper solution to this is to use an AFTER LOGON trigger to set
CREATE_STORED_OUTLINES to true. If the users have the CREATE ANY OUTLINE system
privilege, you'll be able to see which indexes are being used in the
DBA_OUTLINE_HINTS view.
@ Regards,
@ Steve Adams
@
I don't think you can use rman by sqlplus. If you have backed up your
archive logs to tape you can restore them using rman. Here is a script to
recover archived logs 216 and 217. First you have to restore the archivelog
backupsets to the backup destination from the tape. The run the commands
On Tue, 29 May 2001,Oweson Flynn scribbled on the wall in glitter crayon:
-(Roland, that is a bit like asking 'How do I implement world peace?' or 'How
-do I understand women?' - we can't help make a query run faster per se - a
you do not understand women, if you are very, very, very lucky you
Keep an eye on free memory -- one of our similar systems has to be restarted
every 60 days to prevent the behaviour you're encountering. We haven't
determined the source of the memory leak, but if we permit it to continue
eventually the DB stops responding and cannot be shut down. This system
Rahul,
It seems to me that you are having a problem reading the proper TNSNAMES.ORA for
the different DBs. What I would do in your situation is to search for all
TNSNAMES.ORA files in your PC, since you have products installed in more than
one home and more than one version you should have
I believe this always was like this.
If you look on my site I beleive it is under user I have a Who script.
It lists who is logged on, it handles this occurance and removes the domain.
As well as the path from the program column.
http://www.vampired.net/scripts/php/user.php (First one in the
Ruth
I don't see the scrip you talking about here, when you say you are
restoring 216 and 217. It's not included on yhour mail!!!
On Tue, 29 May 2001 05:56:20 -0800 Ruth Gramolini
([EMAIL PROTECTED]) wrote:
I don't think you can use rman by sqlplus. If you have backed up
your
archive logs
Title: RE: Listener.logwriting to renamed file
You
should bounce the listener.
"Walking on water and developing software from a
specification are easy if both are frozen."
Christopher R. Spence Oracle DBA Fuelspot
-Original Message-From: Li, Xiangli
[mailto:[EMAIL
First of all, I'm a beginner to SQL/SQL Loader.
Currently,I'm working with Oracle 8.
I would like to know if it's possible invoke SQL Loader inside a script.
Example:
- inside the script I want to create a new table TABLE1
- copy some data inside TABLE1 using SQL loader
- work on TABLE1 using
All,
I was told a while a go about a new suite of utilities called 8i Change
control (or
Impact analysis) which will look at an oracle 7.3 (not 2) and above
database and show you all the impacts, pl/sql, tables, columns etc etc. of
an upgrade to 8i.
Anyone else heard of such a thing. I was told
Title: ORACLE 8i DBA
1) Que Oracle 8/8i is great startup book as well as the Oracle
Press DBA Handbook
2)
Read, Practice, Read
3) I don't believe in cheating, so no help
there
4) Way to many sites to mention, start with any oracle site and
just follow links.
"Walking
on water and
FOR YOUR INFORMATION
ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has
changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails
using the old format will continue to be delivered until 30th June 2001.
I posted a message on the list several
I'm working on a database security audit at a new place and was trying
to get a list together of all the default accounts Oracle may create so
I can make sure their passwords have been changed.
I've heard there are 15 or more accounts now. Does anyone have a list
they would care to share? I'm
who
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Quaglio Andrea
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
Thanks for all who replied.
Probably I will have to solve this some other way, since the customer has
several instances on the same box, but the instance name has no correlation
to the SID name: they don't accept the default.
Regards,
Tamas Szecsy
-Original Message-
Sent: Tuesday,
I did not understand this note. Does it mean that I can copy current
alert.log to alert.log.old and then mv nullfile alert.log and original
oracle using original file descriptor will write to new empty alert.log?
Alex Hillman
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Sunday,
Sorry about that! Here it is. And it is to restore 217 and 218. The
other script allocate and release the channels.
replace script restore_archivelog {
execute script alloc_dc1_disk;
restore archivelog from logseq 217 until logseq 218 thread 1;
execute script rel_dc1_disk;
}
--
If you
Go thru as many practise exams as possible and PRACTICE.
Prakash
-Original Message-
Sent: Tuesday, May 29, 2001 9:35 AM
To: Multiple recipients of list ORACLE-L
hi
I am planning to take ORACLE 8i DBA Examination, Can you guys please guide
w.r.t
1) Good Book to Refer
2) Steps
I've been working in Oracle for 4 years and Access for 6 years, and
can assure you that for Access 97 (size limit is 1 g), Access 2000
(size limit is 2 g), Access 2002 (size limit is 4g). I've had 500 mg
database that work fine in a multiuser environment, however if there
is a need for a
Hello
We are running into a little problem with an Oracle installation. The server
OS is Windows NT, SP6, and the version of Oracle is 7.3.4.5.0. The server
have 4 processes, we have about 1,7 G primary memory and about 2 G of memory
on swap disk. We have 4 processes in the machine. One of these
see the host command in pl/sql
[EMAIL PROTECTED] 05/29/01 11:15AM
First of all, I'm a beginner to SQL/SQL Loader.
Currently,I'm working with Oracle 8.
I would like to know if it's possible invoke SQL Loader inside a script.
Example:
- inside the script I want to create a new table TABLE1
-
Hey, Christopher, I hope this isn't a blatant plug for the site !
:-)
(just joking, I have been on it a couple of times - very nice !!).
-Original Message-
Sent: 29 May 2001 15:51
To: Multiple recipients of list ORACLE-L
I believe this always was like this.
If you look on my
Fyi for those who might be working on this, see technical notes:
138118.1 Installation Procedures and Potential Problems for 9iAS 1.0.2. on
NT
117145.1 Installing Oracle8i Cache
132445.1 9iAS/Portal Install on NT with 8.1.7.
There is a patchset 3a for Forms and Reports 6i, and a patchset
Ignore my prior post about default accounts. I saw the list on orafaq
but wasn't counting the 5 training accounts (scott/tiger) in my list as
defaults and kept coming up short on the 15 or 16 'defaults'. Once I
added them in it makes more sense with a post I saw on MetaLink from
Oracle Support.
Andrea,
Is this UNIX or NT.
In UNIX ( I don't know NT that well), the most simple method would be to use
a shell script.
The following is about as basic as it comes but would need to be embellished
with environment settings and error checking etc..
eg.
Start of Script
Hi all,
We had gotten some extra memory for our production server and I was trying
to increase our buffer cache again (I was leery of doing it all at once so I
just doubled it the first time). I got a
ORA-27123: unable to attach to shared memory segment
with my first try (it worked after I
You need to change sgabeg re-link Oracle.
The values below are/were valid for V7 and
should be used with caution on V8.
HTH YMMV!
sgabeg = 0xe000 ! 256MB SGA
sgabeg = 0xd000 ! 512MB SGA
sgabeg = 0xc000 ! 768MB SGA
sgabeg = 0xb000 ! 1.00GB SGA
sgabeg = 0xa000 ! 1.25GB
what
-Original Message-
Andrea
Sent: Tuesday, May 29, 2001 11:47 AM
To: Multiple recipients of list ORACLE-L
who
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Quaglio Andrea
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX:
Hi,
I need some help...I am trying to use SQL loader
to load a flat file into a table...the problem I have is that
when trying to load a blank column into a date column...
this throws out an error...and the loader fails...do you know of a way of
how
to get around this problem...how can I
I have a server NT4.0, SP5 that has two versions of Oracle installed. On
drive J is Oracle 8.0.5 which is used by a third party app and has been up
and running for about a year. This last week I installed on drive E Oracle
8i 8.1.7 and have not yet created a database. This Saturday on of the
When and how
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, May 29, 2001 1:41 PM
To: Multiple recipients of list ORACLE-L
Subject:RE:
If it is NT you can create a batch file similar to Unix example given below
which will do the same. The only difference here is you'll have to save
your sqlplus scripts in a text or *.sql format and call them from the batch
file. After that you can call sqlloader.
-Original Message-
Inside Pl/SQL u cannot use the host command.. HOST is Sql*PLUS command not a SQL. So,
u cannot use with in Pl?SQL
Rajaram
-Original Message-
From: William Beilstein [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, May 29, 2001 12:08 PM
To: Multiple recipients of list ORACLE-L
Subject:
Jonas,
Solution, dump Windows and get onto Linux or buy a real Unix machine. Your
asking a toy to do a man/woman's job.
Dick Goulet
Reply Separator
Author: Jonas A Wetterberg [EMAIL PROTECTED]
Date: 5/29/2001 8:50 AM
Hello
We are running
Yes, Dan is right,
I just pulled up this info from Acess Help ( U can find more info when u
search for Specification in access help)
***
Database specifications
***
Attribute Maximum
Database (.mdb) file size 1 gigabyte. However, because your database
Hi,
Take a look at the nullif clause.
tom
-Original Message-
Sent: Tuesday, May 29, 2001 12:41 PM
To: Multiple recipients of list ORACLE-L
Hi,
I need some help...I am trying to use SQL loader
to load a flat file into a table...the problem I have is that
when trying to load a blank
Rao,
Somewhere on this list there is a fellow from Quest, I've seen his e-mail,
but can't remember who it is. Therefore If I'm leading down a wrong path he can
correct. Anyway, as I understand SharePlex it extracts the transactions from
the archived redo logs to replicate those
Hi
Go for Oracle Certified professional DBA
certification Exam guide By Jason S couchman Ulrike
Schwinn
This is one of the best for for ocp exams it contains
lot of practice exams and is desinged for OCP only
Other than this for crampsession u can go to
brainbuzz.com site here u can find
And Where.
Terry
Boivin, Patrice J wrote:
When and how
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, May 29, 2001 1:41 PM
To: Multiple recipients of
Hi
Sorry if I sound naive!
But do we have to boot the server in Solaris 8
TOO (!!) in order to change the kernel?
What is the procedure for changing the kernel
Thanks
- Original Message --
John Kanagaraj [EMAIL PROTECTED] wrote:
To:Multiple recipients of list
I was actually expecting a comment or two like that given what I got last
time, good heavens I do something for free for someone and promote it.
I am such an evil man.
Hopefully it gets better, been slow but it's coming along.
Walking on water and developing software from a specification are
You can ask the listserv, send this commmand to [EMAIL PROTECTED]
WHO list
Sends a list of all subscribers to the list specified. This list may be
partially or completely blocked, depending on the configuration specified
by the list administrator. Most subscriber lists are ONLY
On Tue, 29 May 2001,Cyril Thankappan scribbled on the wall in glitter crayon:
-
-Hi
-
- Sorry if I sound naive!
-
- But do we have to boot the server in Solaris 8
- TOO (!!) in order to change the kernel?
-
- What is the procedure for changing the kernel
-
* Thanks
As far as I know, if you
Title: RE:
but why?
-Original Message-
From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 29, 2001 1:26 PM
To: Multiple recipients of list ORACLE-L
Subject: RE:
When and how
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
Thanks!
I'm reading the Ixora site for information on sgabeg right now (never know
about the 1.7 Gig default limit before). A search of the Oracle docs and
the Alomari book didn't turn up anything.
From there to shudder Metalink :).
Jay
-Original Message-
Sent: Tuesday, May 29, 2001
Hi there,
Anybody have experience setting this parameter? It references a bug
(1210242) that apparently causes certain cursors not to be shared if timed
statistics is set to TRUE.
Thanks!
- Jerry
=== from Main issues affecting the Shared Pool on Oracle 7 , Oracle8 and
Oracle8i , Doc ID
That is clever Steve.
I'm gonna go play now. :)
Jared
On Tuesday 29 May 2001 07:00, Steve Adams wrote:
Hi All,
A cheaper solution to this is to use an AFTER LOGON trigger to set
CREATE_STORED_OUTLINES to true. If the users have the CREATE ANY OUTLINE
system privilege, you'll be able to
Dave,
It seems to me that you are having a problem reading the proper TNSNAMES.ORA for
the different DBs. What I would do in your situation is to search for all
TNSNAMES.ORA files in your PC, since you have products installed in more than
one home and more than one version you should have
On Solaris, you don't actually have to change the kernel, but you
do need to edit the file /etc/system, and these changes require
a reboot to become effective.
I know this to be true through 2.7, not sure about 8.
Jared
On Tuesday 29 May 2001 11:28, Cyril Thankappan wrote:
Hi
Sorry if I
Hi!
Has anybody used it?
It sure promises a lot...
and I guess would also be a good product to use.
however, we had problems 'integrating' it with
the backup device !
Thanks
- Original Message --
C.S.Venkata Subramanian [EMAIL PROTECTED] wrote:
To:Multiple
JM ,
check metalink following metalink note ,
Note:15566.1
Regards
RS
--- Miller, Jay [EMAIL PROTECTED] wrote:
Hi all,
We had gotten some extra memory for our production
server and I was trying
to increase our buffer cache again (I was leery of
doing it all at once so I
just doubled it
Rao,
Contact QUEST and see if they are holding any SURVIVAL deminstrations in your area.
They are very informative and will answer a lot of your questions. I would suggest
that you also invite your damagement to help in making the decision.
ROR mª¿ªm
[EMAIL PROTECTED] 05/29/01 01:16PM
List,
All,
We are currently as customer of Quest Software using LiveReorg and
Spotlight. For those who don't know, LiveReorg is a combination of two
existing Quest products, Space Manager and SharePlex. I asked the exact
same question regarding the mining of redo logs of our Quest sales rep. I
In the CONTROL file that describes the columns to load from the data file you can load
a FILLER type column desc into the destination table if the column does not exist in
the source data file. If the source data column contains nulls then a NVL will convert
a null to what ever you want to
when?
But, more important, WHY???
-Don Granaman
[certifiable OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, May 29, 2001 1:28 PM
And Where.
Terry
Boivin, Patrice J wrote:
When and how
Patrice Boivin
Systems
Why change it to subqueries?
The optimizer will just turn it back into a join anyway.
Jared
On Tuesday 29 May 2001 05:15, [EMAIL PROTECTED] wrote:
Hallo you DBAs
How can I write this sql query using subqueries?
SELECT pbk.nielsenart.varunamn, pbk.nielsenart.strl,
Title: RE: Your views on Quest - Shareplex
As of a year ago it was single threaded and didn't handle long columns.
-Original Message-
From: Rao, Maheswara [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 29, 2001 10:17 AM
To: Multiple recipients of list ORACLE-L
Subject: Your views on
The only way we've found to do that is to collect the parameters through an
Oracle Form, which allows more sophisticated design. Then call the report
from the form, passing the parameters.
I do wish Oracle would allow parameter-level triggers such as
WHEN_LIST_CHANGED in Reports. That would
That is the case, I agree, then you should still be able to use both of you
sqlplus's, not that it really matters though.
Kev
-Original Message-
DeUrioste
Sent: Tuesday, May 29, 2001 3:01 PM
To: Multiple recipients of list ORACLE-L
Dave,
It seems to me that you are having a problem
Wow, two people actually got my after memorial day humor!!
-Original Message-
Sent: Tuesday, May 29, 2001 2:28 PM
To: Multiple recipients of list ORACLE-L
And Where.
Terry
Boivin, Patrice J wrote:
When and how
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
On Tuesday 29 May 2001 12:01, Jim Hawkins wrote:
From note on MetaLink:
1) There is not sufficient information in the logs to logically
replicate transactions, so the data applied to the destination system
may be different from the primary, and therefore inaccurate.
So how does a
As Jared pointed out (shame on me), there is no host command in PL/SQL, the only place
where the host command is supported in in sqlplus and forms.
Jared Still [EMAIL PROTECTED] 05/29/01 02:10PM
On Tuesday 29 May 2001 09:07, William Beilstein wrote:
see the host command in pl/sql
Bill, I
You won't find performance gains by using views, and
in fact the exact opposite can happen.
If you make use of views, you *must* read the 'Designing and
Tuning for Performance' manual, as there are certain types of
SQL statements that you don't want to use in a view.
Personally, I prefer not
I am trying to pass a shell variable into a here document in a unix shell
script, i.e.,
export PASSWORD=the_pass
svrmgrl EOF
connect user/$PASS
do_stuff_here;
commit;
exit
EOF
I have tried: $PASS , \$PASS , and just plain $PASS - no dice.
Anyone know how to do this? I spent too many hours
I made this script available on my site with due credit to the author.
I made a small modification on the set variables so they will be read by
PL/SQL developer and other non-sql plus clients.
(I actually already copied it up there, but didn't know who wrote it so I
had it as Anon).
Walking on
Jonas,
In addition to Dick's comments about a real Os ( with which I concur ) you
need to do that math. You are running 170 sessions on the database.
You can count on each session eating up 5 meg of RAM with 7.3. If you
go to 8i, you can at least double that figure. This is all dependant
No, but Query one is better, it will allow you to adapt to changes. If
someone adds a column to your table and you select *, all of a sudden all
your applications break as there are more columns than originally
inticipated. You can program to prevent this, but naming all the columns is
#1 self
Title: OT: Tool needed for database access
Hi -
We are a sybase and oracle shop. We are considering building a tool (probably web-based) to allow the Security group to set up new users and to allow the developers to add stored procedures as the schema owner, etc. We don't want them to have
1 - 100 of 179 matches
Mail list logo