Hi All
Can anyone recommend me the book for SQL/PLSQL OCP exam paper. I
would like to know the book which will be guiding me thoroughly
Amol
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nandu Garg
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 5
Hallo,
anyone know knows any webpage where I can ask MsAccess questions about error messages?
Thanks in advance
Roland
--
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
Hello,
How do I disbale "connect sys as sysdba" with a null password. Thanks.
ltiu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: ltiu
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Publi
Forgot something the call from inside the check_all_exfail.sh script looks
like this...
exfail.sh $EXFAIL_OPTIONS $ORACLE_SID
-Original Message-
Sent: Tuesday, March 05, 2002 10:23 PM
To: Multiple recipients of list ORACLE-L
I have a shell script called exfail.sh which checks for poten
Anyone know what patterns are typically recognized as errors in the
listener.log file? ORA-, "error" etc...?
Thanks,
Ethan Post
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Post, Ethan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX:
Fair Point,
but isn't Async I/O limited to Raw Devices only: If not using raw, many
companies don't, you can still face contention issues.
Also enabling more dbwr processes gives the overhead of more background
processes: I feel that multiple files per tablespace is a workable
compromise.
--
On Tue, 5 Mar 2002, Kimberly Smith wrote:
> Kevin, let me introduce you to the world of stripping. Course, if
> you are on old hardware that really isn't like it is today.
I was unaware of the concurrent data access benefits of stipping. I
did know about certain things being spread out, but us
Ian,
I'll start with some easy questions:
What version of Oracle and what OS?
Can you show the SQL being run or some of it?
What does v$session_event and v$session_wait show?
Can you reproduce it when you run the SQL called by the program from SQLPlus?
I had a problem ion 815 / NT with really rea
I have a shell script called exfail.sh which checks for potential extent
failures on a database. The script accepts a couple of command line
switches.
exfail.sh -p -g "dba apps" TEST
Basically this says run the exfail.sh script against the "TEST" instance,
(-p) page people if there are problems
The services are set to start automatically and version for the Oracle is
(Oracle Standard Edition 9.0.1) on windows and we open a tar with oracle
india suppport but no help as of now.
we have reinstalled Operating system (Windows Advance Server with service
pack II) and Oracle Standard Edition 9
Hi All,
I have an online program that is timing out and when I trace
it I get the following at the bottom of my tkprof output. It’s easy to
see why the transaction is running slow, because of all the parsing. But the
program and all called modules are compiled with max_opencursors = 75
And how is this different from OEM data guard manager/broker?
joe
James Forgy wrote:
> March 5, 2002:
> Relational Database Consultants, Inc. (RDC) - Proudly
> announces the release of the Standby Wizard For Unix &
> Linux. The Standby Wizard is a GUI interface that
> automates the creation, m
Sweet. Sounds like a solid setup to me.
-Original Message-
Robert
Sent: Tuesday, March 05, 2002 10:43 AM
To: Multiple recipients of list ORACLE-L
Well, I have a slightly different way of approaching file sizing. Here we
have Hatachi storage array's on a FIDI setup. We stripe several dr
Kevin, let me introduce you to the world of stripping. Course, if
you are on old hardware that really isn't like it is today.
-Original Message-
Sent: Tuesday, March 05, 2002 7:09 AM
To: Multiple recipients of list ORACLE-L
I am sure its been said in the notes I have not read yet
Please, try ORADIM command utility.
Ferry Situmorang:
Using Oracle 8.1.7 Designer 6i R4
PT Perkebunan Nusantara XIII (Persero)
Pontianak-Indonesia
http://www.ptpn13.com
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, March 04, 2002 10:23 PM
Hi Rajendra,
The reason of this test is that I want make sure Oracle able handle division
by 0 properly
without giving me nice blue screen.
Sinardy
-Original Message-
Rajendra
Sent: 05 March 2002 21:18
To: Multiple recipients of list ORACLE-L
Pardon my expression, but Why in the worl
Greg,
I recognize that Guy ;-)
Someone else said back-channel that they thought Harrison's book mentioned
the requirements. And since I had the book handy, I looked it up. Should
have thought of looking there. Nonetheless, thanks for taking the time to
type up the comments from the book. I appre
ok.
Thanks for answers.
Regards
Eriovaldo
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, March 04, 2002 11:18 AM
> Eriovaldo,
>
> If I were you, I would create a small test database on the production
> machine, and perform backup/res
March 5, 2002:
Relational Database Consultants, Inc. (RDC) - Proudly
announces the release of the Standby Wizard For Unix &
Linux. The Standby Wizard is a GUI interface that
automates the creation, maintenance, and fail-over
functions of Oracle's standby database paradigm. With
the Standby Wizard
Bruce,
You can load Oracle Names from a tnsnames.ora file, the repository is
not required. Setting it up this way is fairly easy.
Jared
"Reardon, Bruce (CALBBAY)" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/05/02 03:18 PM
Please respond to ORACLE-L
To: Multiple recipie
Stephen or others,
If I understood correctly, the email below said it is possible to have a Names Server
that doesn't require its own database.
I have just briefly read the manual on Names and it mentions that Names8 doesn't
require a database to store topology but it is recommended.
It also me
So the answer is none of the above.
-Original Message-
Sent: Tuesday, March 05, 2002 5:48 PM
To: Multiple recipients of list ORACLE-L
You did not specify in, out or in out, so the default is: IN.
Parameters that are defined as IN don't get copied but are referenced
(passed by reference
Clearly the best guess is (e) - none of the above.
It is unlikely to be based on incoming data for
reasons of bounds checking. Which means that
you have given us 3 static values from a range of
32767 which may be possible. ;)
I haven't checked it - but if I had to guess, I
would guess, based on
I believe that the President of OraKnowledge (Ed Haskins) is a member of
this list.. (?)
Mark
-Original Message-
Nemeth
Sent: 05 March 2002 20:36
To: Multiple recipients of list ORACLE-L
Has anyone gone through OraKnowledge's eboot camp? If so, what are you
thoughts?
http://www.orakno
You did not specify in, out or in out, so the default is: IN.
Parameters that are defined as IN don't get copied but are referenced
(passed by reference).
Regards,
Waleed
(I hope I'm right!)
-Original Message-
Sent: Tuesday, March 05, 2002 4:48 PM
To: Multiple recipients of list ORA
Hi ,
This is from one post in other shell group ..
I forgot who is the poster.
#! /bin/sh
year=`date +%Y`
month=`date +%m`
day=`date +%d`
# figure out what yesterday was.
day=`expr "$day" - 1`
case "$day" in
0)
month=`exp
Sean,
I'm also interested in this and whilst I can't provide a definitive answer I can
provide some numbers and a script that I'm using - if anyone can point out problems or
issues with the script I'll learn and correct them.
Anyway, script is below (originally written to try to help find a me
Riddle me this Batman.
Assume Oracle9i...
assume you have a table thusly defined:
Table Name: TEST
col_1 number
col_2 varchar2(200)
And now a procedure defined thusly:
create or replace procedure blah_blah
( p_in_one test.col_2%type )
Now, here is the question, how much memory will p_in_
How was the service created? Is it set to automatically start?
Jared.Still
@radisys.com To:
Alex,
Can you elaborate this with an example (meaning exact syntex).
thanks
Santi
-Original Message-
Sent: Tuesday, March 05, 2002 12:30 PM
To: Multiple recipients of list ORACLE-L
pipe df -k to awk and sum the column you want
On Tue, 5 Mar 2002, Nguyen, David M wrote:
> Does someo
Has anyone gone through OraKnowledge's eboot camp? If so, what are you thoughts?
http://www.oraknowledge.com
tia,
David
__
Do You Yahoo!?
Try FREE Yahoo! Mail - the world's greatest free email!
http://mail.yahoo.com/
--
Please see the official O
> working with some folks who are frightened by anti-joins
Last Halloween I went as an anti-join. It was pretty scary.
Harrison:
"Performance from the hash antijoin was dramatically better than for any
other [anti-join optimization] method we tried.
...
To take advantage of Oracle's antijoin
Has anyone taken the initial 9i OCP exam
(1Z0-007)?
I'd like your feedback.
Thanks,
Ken Janusz, CPIM
Hi Hemant,
I did a conversion of 4.5 forms to 6i in Windows, Motif and Web environments
simultaneously 2 years ago. I must tell you that the biggest challenge was
the Motif environment (well, I did have some challenges with the web stuff
too). Of course, we were also trying to keep everything wi
pipe df -k to awk and sum the column you want
On Tue, 5 Mar 2002, Nguyen, David M wrote:
> Does someone know what command can be used to display total capacity of disk
> drive? I can use command "df -k" but it breaks partitions apart so I have
> to add them up. I need command just display a t
I have two repositories in test and will have 2 in production. One to
backup the databases (an instance unto itself) and one to backup the RMAN
instance (schema within one of the lesser instances). In a perfect world
where you have acres of dasd and unlimited everything, I guess it might be
clea
I am fairly new to RMAN, but here is my $.02. Use a separate RMAN db for each version
of db's to be backed up (e.g. rman817, rman901, ...). In each RMAN db, I would create
a separate schema, same name as Oracle_SID for each db. This model makes scripting,
maintenance, and upgrades simple. N
I have a dedicated RMAN database (8.1.7.2) to support the RMAN catalog.
Should I run this RMAN database in "cost-based" or "rule-base" optimizer
mode ?
_
Patrick J. Howe
Oracle DBA
Illuminet Inc. (Carrier Division of Verisign)
4501 Intelco Loop SE
Olympia, WA 985
We switched to names server last year. We had our NT administrator net use
to each client in the company (effectively assigning a drive to the
administrators machine) and copy the sqlnet.ora over to the remote
machine. Fired up about 10 machines and updated > 1000 systems in three
different waves
Jared,
I think he is talking about direct grants. Not granting through a view.
SQL> grant select on X$BH to system;
grant select on X$BH to system
*
ERROR at line 1:
ORA-02030: can only select from fixed tables/views
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Orig
Well, I have a slightly different way of approaching file sizing. Here we
have Hatachi storage array's on a FIDI setup. We stripe several drives,
RAID, and get quite good performance.
I do NOT limit datafiles to any particular size (in production). Why?
Because I want to eliminate, as much as pos
Pat,
This makes no sense to me. I have one Rman catalog for all our databases
that are at the same release level.
I can see separate Rman catalogs for different release levels, but even this
is not necessary. Lower levels of Rman work with higher levels of the Rman
repository.
Hope this helps
Yechiel,
That's all well and good if you get to set it up from the beginning.
I inherited it. Tnsname.ora everywhere. Different desktops with
different names for the
same databases. It's a nightmare. I plan to setup Onames when I get a
chance to do so.
Putting tnsnames.ora on netw
Pat
There are several reasons to have multiple catalog, but the most
importen one is that gives the possibility to upgrade the catalog
without interfering
with other database backup's. There is as well the benefit if you at
some time is going to query the catalog using Sql you will not have t
Hi Pat,
to cut to the chase here is how we do it in our shop
..
we have :
1. East Coast: we have bunch of DB's & 1 tape server
2. West Coast: we have bunch of DB's & 1 tape server
Rman Strategy:
We have two catalogs, one which caters to all db's on
east coast and backs ups db's on east coast ta
Maybe I'm an anachronism, but I've tried IDE's for programming, and
just can't seem to give up vi and sqlplus.
If you get into some real heavy duty unit testing, throw 'make' into the
mix.
Jared
"Mark Leith" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/05/02 02:43 AM
Please respond to
I'll take the easy question.
There's nothing preventing you from granting privs on the x$ tables.
See:
http://www.ixora.com.au/scripts/sql/create_xviews.sql
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
03/04/02 04:53 PM
Please respond to ORACLE-L
To: Multiple recipi
It might be possible for someone to help you if
you include the relevent OS info ( version and service packs )
and the oracle version.
Praveen Sahni <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/04/02 11:13 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORAC
I have just completed Oracle Education's "Enterprise DBA Part 1B: Backup and
Recover" course.
Page 11-5 states : It is recommended that you have a separate catalog for
each database.
My question is :
Why? Does this help you cleanup the RMAN catalog if you ever drop a
database (you can drop the
Hello,
I have used this dynamic script (on 8.1.6.x and 8.1.7.x) successfully with
no corruption, for the past two years. The script actually moves the indexes
from where they are originally built on a data tblsp to its index tblsp.
However, dropping the "and tablespace_name = 'TBLSPD'", will resu
Having 500mb, and then 4 50mb data files is over killed. Have multiple
files per tablespace is generally good pratice and should make them same
size. We have limited the database files to 2G for just one reason. That
reason is that if you have to recover a database or move to another box, it
is
Works great on 9.0.1
david
David B. Wagoner
Database Administrator
Arsenal Digital Solutions Worldwide, Inc.
8000 Regency Parkway, Suite 110
Cary, NC 27511-8582
Tel. (919) 466-6723
Fax (919) 466-6783
Mobile (919) 225-4962
[EMAIL PROTECTED]
http://www.arsenaldigital.com/
*** NOTICE ***
Thi
Hi,
To see the size of all disks and partitions (SCSI and IDE):
PHS7:/proc $ cat partitions
major minor #blocks name
8 02202244 sda
8 12200873 sda1
8164406935 sdb
8174401778 sdb1
8324406935 sdc
8334401778 sdc1
3 0 146
I'm still back on 8.1.6 and when I tried to use 'alter index rebuild online'
I got corrupted indexes. I saw on metalink that it's supposed to be fixed by
8.1.7.1 - anybody using successfully now?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Shaw John-P55297
INET: [
We
have Sun Cluster 2.2 2 node cluster, 1 Sun E6500 (14 CPUs) and 1 Sun E5500 (11
CPUs), Oracle 8 and EMC Symmetrics storage. It takes about 3 minutes for
failover of 200+GB database.
Michele
-Original Message-From: Nick Wagner
[mailto:[EMAIL PROTECTED]]Sent: Monday, March 04,
I just downloaded the free version of TOAD (6.3.11.1g) and it
works without any errors on 9i. (9.0.1 on XP Prof. / DELL
8200).
Ken Janusz, CPIM
I'm trying to get a handle on the amount of memory allocated to a dedicated
server process using NT. From having examined manuals to to begin with the
terminology seems to be inconsistent. There appear to be interchangeable
references to PGA and UGA and also to Dedicated Server Process memory an
Disk capacity is relevant to partition. Your df -k could show 10 partitions, this
could be 10 1 drive, or 10. You might find what you need in fdisk, but use it with
caution if you aren't a unix admin.
-Original Message-
Sent: Tuesday, March 05, 2002 9:59 AM
To: Multiple recipients of
Thanks Mike, I'll keep an eye out for it.
Lee
-Original Message-
Sent: 05 March 2002 15:29
To: Multiple recipients of list ORACLE-L
Lee,
Be aware of bug 2220597. I believe metalink identifies other 64bit OS's,
but I've experience it on Tru64 5.1 (1885). Not sure if there is a bug f
- Original Message -
> Does someone know what command can be used to display total capacity of
disk
> drive? I can use command "df -k" but it breaks partitions apart so I have
> to add them up. I need command just display a total.
>
for an IDE drive do:
cat /proc/ide/xxx/capacity
..
Hello All
I saw some remarks about updating tnsnames on many desktops.
Why would you have tnsnames in every machine?
I put our client software on a central server, with the tnsnames.
One update to the tnsnames in the server apply to all.
Installing for a new PC is importing the registry entries
a
Hi, I have heard and saw a demo on the top of the line
laptop from Apple, that you can download jdeveloper from the
Oracle Technet web site. Get the Linux version.
suppose to run something like ./jdeveloper with no modifications.
This might be a start for using the iMac with Oracle.
Who did the
500 M for batch transactions?
--
Chris J. Guidry P.Eng. EE
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]
> -Original Message-
> From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, March 04, 2002 07:28 PM
> To: Multipl
I am sure its been said in the notes I have not read yet but, my
biggest reason for having the multiple files is to have multiple drives.
Each file on a different drive means that the access to the file can be
spread out. Therefore you can have multiple processes accessing the files
at the s
Lee,
Be aware of bug 2220597. I believe metalink identifies other 64bit OS's,
but I've experience it on Tru64 5.1 (1885). Not sure if there is a bug fix
available yet.
Mike Hand
Polaroid Corp
-Original Message-
Sent: Friday, March 01, 2002 3:23 AM
To: Multiple recipients of list ORACL
I sometimes think that every os-dependent parameter in Oracle is secret.
Oracle doesn't publish that information, and the OS vendors usually have no
idea or are not likely to publish that info either.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Ad
Title: RE: Number / 0
Sinardy
You are trying to create a function based index. To do so you need the query rewrite privilege
The index will still fail with a divide by 0 error (don't know why you are dividing by zero)
AS USER
create index wrong_logic on john(income/0)
Hi Kim,
Ahamed Alomari (Oracle8i and Unix Performance Tuning p142-143)discusses this
in more detail. However I don't think this is more relevant with the Async
IO and multiple DB Writers.
But this is a serious issue in older versions (oracle 7 and below) because
the number of Asnyc IO thread req
Does someone know what command can be used to display total capacity of disk
drive? I can use command "df -k" but it breaks partitions apart so I have
to add them up. I need command just display a total.
Thanks,
David
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: N
Assuming that the lob itself is in another place,
I seem to remember that the pointer in the row
is 37 bytes.
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
> -Original Message-
> From: Seema Singh [SMTP:[EMAIL PROTECTED]]
> Sent: Mon, March 04, 2002 4:43 PM
> To: Multiple re
I agree with everyone. Oracle Names saved many days/months of maintenance
time in migrating new TNSNAMES to over 3 desktops. The only gotchas
with ON was the creation of a separate Administrative database and 24x7
maintenance of it. With the new extensibility features not requiring a
databa
Ah, but we use partitioning. However, the design you described is
slightly flawed me thinks. I had to do something similar at the last
job and what we did is have a separate tablespace for each month, which
in turn produces a separate data file of course. Not that there was
anything wrong in wh
I had the opportunity to work with a very good sys
admin. We used raw on an EMC Sym and managed it all
with Veritas. We both decided to keep our datafiles
no bigger than 1GB regardless of TS size and at least
4 datafiles per TS. We used 36GB drives in our Sym,
each divided into 9GB LUNs. Our r
Using Sql Backtrack for backups, you are able execute the backups of multiple
datafiles in parallel. Therefore, it will be faster to backup 4-1g files
rather than 1-4g file if you have the necessary hardware in place.
4:58 AM
PST
Please respond to [EMAIL PROTECTED]
Sent by:[EMA
Hi,
We are running Oracle 8.1.7.2.0 with Solaris 8. (Sparc)
We are using read-only snaphots with multiple groups (one/schema),
replication every minute. Simple 'select *' replication.
One of the snapshot process seems to stall and all access to one of the
tables in the actual group is blocked
For our OLTP systems, we standardize on all data files to be 2GB (basically
for each data file we have additional two backup locations as well). Then we
use whatever amount we need and keep remaining so that data file can be
extended up to 2GB when required.
It has been working well for us, and i
True, but its a rare case that I need to restore just one data file.
That being said, it would not be to much different with those sizes.
A 10G and a 2G you might notice it...
-Original Message-
[EMAIL PROTECTED]
Sent: Monday, March 04, 2002 9:48 PM
To: Multiple recipients of list ORACLE-
FWIW, there is a strong case for keeping consistent datafile sizes, similar
to the argument for extent sizes. This makes for easier file exchanges for
hot to not-so-hot disks, or copying the database to a new system. And
segment extent size should be kept in mind, i.e., you don't want to be
add
However, if all the disks that you are spreading the files out among
are stripped you lose that advantage do you not? We strip then mirror,
so we have multiple big strips and partition against that.
-Original Message-
[EMAIL PROTECTED]
Sent: Monday, March 04, 2002 9:48 PM
To: Multiple r
Do you know of a web site where I could research particular thought
on? I have not seen anything like that in my research. Thanks.
-Original Message-
[EMAIL PROTECTED]
Sent: Monday, March 04, 2002 8:53 PM
To: Multiple recipients of list ORACLE-L
In a UNIX system it is better to have m
Pardon my expression, but Why in the world are you dividing by zero?
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD:
Yes, and that's exactly what I was suspecting. Thanks for the quick
confirmation.
-rje
KG> I guess you are looking in 'itc' in block dumps which shows the
KG> ITL Count.
KG> And yes.. There is an upper bound for number of ITLs based on the
KG> block size. The transaction slots (and other head
I've found the note. It wasn't what I remembered,
it was worse. I've just re-run a test on 9.0.1.2
that shows an interesting issue:
create table t1 (n1 number, v1 varchar2(10));
create index i1 on t1(n1) pctfree 0 initrans 10;
insert into t1
select rownum,'x'
from all_objects
where rownum <=
Not using the RBS tablespace as the tablespace of discussion because it
has special requirements and can create a lot of discussion.
I can fore see a reason for using multiple datafiles in a tablespace.
Lets say that you have a large table than contains information based on
dates. you load the ta
Hi Kathy,
The only thing I can think of for your original question is a bad guess on
the file size. They
guessed 500 mb, ran out of file space, added a 50 mb file to the Tablespace,
ran out again
added 50 mb again. never ran out again.
Reading other dba's minds is so much fun :-)
John
[E
yowch! that tickles
--- "Farnsworth, Dave" <[EMAIL PROTECTED]> wrote:
> >-someone shoot me
>
> Bang!! As the dart with the suction cup firmly attaches to Rachel's
> forehead.
>
> ;o)
>
> -Original Message-
> Sent: Monday, March 04, 2002 8:23 PM
> To: Multiple recipients of list ORACLE
I use 10gb datafiles for a 1tb db and also back up using Legato. Thinking about using
Rman :)
>>> [EMAIL PROTECTED] 03/05/02 03:18AM >>>
We use 4Gb datafiles here as the norm without any problems at all and those
datafiles are all backed up with Legato. No problems whatsoever.
Lee
-Origi
I would try select * from sonusrpt where upper(subject) like '%GENERAL%';
Might be a case issue w/ subject - if the word is General as you state above, you are
searching for general below.
Good Luck
-Original Message-
Sent: Monday, March 04, 2002 3:33 PM
To: Multiple recipients of list
>-someone shoot me
Bang!! As the dart with the suction cup firmly attaches to Rachel's forehead.
;o)
-Original Message-
Sent: Monday, March 04, 2002 8:23 PM
To: Multiple recipients of list ORACLE-L
sigh...
someone shoot me. I am spending WAY too much time being unemployed
these days
hello ,
I am getting a syntax error no PCC-W-02044 ,CMD-LINE,Illegal or out
of range value for option for the line below in my program:
EXEC ORACLE OPTION (MAXLITERAL=2000)
any solution for the same??
thanks.
_
Do You Yah
SQLExpert - Leccotech / Cool-Tools (;p) http://www.cool-tools.co.uk
TOAD - Toadsoft / Quest http://www.toadsoft.com
SQL Navigator (?) - Quest http://www.quest.com
PL/SQL Developer - All Round Automations http://www.allroundautomations.com
Rapid SQL - Embarcadero http://www.embarcadero.com
...
...
Hi Nadu,
We use PLSQL-Developer and TOAD. Both are very nice tools. TOAD you can get
free. Here are teh Web-Links.
http://www.allroundautomations.nl/plsqldev.html
http://www.toadsoft.com/downld.html free version
http://www.quest.com/toad/
HTH
Volker Schoen
E-Mail: mailto:[EMAIL PROTECTED]
ht
Hi All
I am facing a lot of problems in testing Stored Procedures and
Functions. I have many functions which requires a lot of
parameters to be passed. Even a small mistake make me lot of
retype.
Again testing everything against requires a lot of testing data.
If any good UI is available it m
Hi,
Connect sys
For the creation of a function-based index in your own schema, you must be
granted the CREATE INDEX and QUERY REWRITE system privileges. To create the
index in another schema or on another schema's tables, you must have the
CREATE ANY INDEX and GLOBAL QUERY REWRITE privileges.
Y
Works nicely for us. It was a bit flakey before we had a region database,
but is rock solid now. I installed OID for a 'play' recently, and after
considerable pain I finally got the GUI running, only to find that what was
on the screen made absolutely no sense to me whatsoever. RTFM'ing had a
s
- Original Message -
>
> I have also an other question.
> Do you you why they did not test postgressql ?
>
I bet they failed to run it on NT (not a trivial task)
Marin
"...what you brought from your past, is of no use in your present. When
you must choose a new path, do
Nice to know the actual strategy.
I came across an oddity some time ago
when trying to work this one out by setting
silly values for INITRANS. This would be
(correctly) ignored on a 'create index', and
then obeyed on a 'rebuild index' with the
result that the index got bigger. I think
it was 8
We use 4Gb datafiles here as the norm without any problems at all and those
datafiles are all backed up with Legato. No problems whatsoever.
Lee
-Original Message-
Sent: 05 March 2002 03:33
To: Multiple recipients of list ORACLE-L
That being said is there anything wrong with having on
Hi guys,
This is my test:
SQL> desc emp
Name Null?Type
-
EMPNO NOT NULL CHAR(3)
NAME VAR
99 matches
Mail list logo
