Hi Kumar,
In my company I have several report that also print the barcode. I think it
isn't big deal if you have font that support the character of barcode.
Rgrds,
Sony
> -Original Message-
> From: Pullikol Kumar [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, February 06, 2003 12:19 PM
> To
Mogens,
Thank You so much for the information .Denmark is quite far away indeed but I
sure can make it if the course is as good as the other courses provided by the miracle
team.Where do you reckon I can get some more details in this regard.
I guess Denmark is a bit far for you to travel? :-). Otherwise, you
could attend the RAC class Bjorn Engsig does here.
Girijan Puthran wrote:
Are there are good courses available for RAC apart from those offered by Oracle ? We are planning to implement a RAC setup at our company pretty soon and
Nitheesh,
Please note that bar code is no special thing other than representing
characters in bars.
You can use a font called bar code font that represents characters as bars.
A free version is available to download at www.idautomation.com
The barcode device connected to a computer reads the bar
upto you if you're sure that your Windows is OK.
But, You have to carefull with the service pack in Windows 2K. I suggest if
your O/S (Win2K) running well ,please don't apply the service if not
necessary.
BTW, What kind of server that you used and spec of the server ?
Thank's
Bernardus Deddy Hoe
Interesting idea! =)
I'll look through the license agreement (OTN) again.
Then find a lawyer who's willing to be a partner...
And who knows...
Thanks a lot to Dennis W, Tim G, Dick G, Stephane F, jeremy P
and Markus R! Thanks to everyone!
I'm still open to any input/ideas/partnerships(?). Feel fr
Hi Lists,
How to generate/Read/Print Barcode using Oracle Forms/Reports ( Windows
/ Unix).
Please Help.
Nitheesh
***
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Pullikol Kumar
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http
Title: windows application to show sql being executed by a client program
Pretty cool...
A future Quest product ??? ;)
Just wondering... :)
-
Kirti
-Original Message-From: Jacques Kilchoer
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 05,
2003 7:59 PMTo
When you buy a "Named User" license do you generally
buy a "Named User Single Server" license or a
"Named User Multi Server" license for the Oracle Database ?
The "Named User Multi Server" license should mean that
a person "A" can connect to any number of databases -- ergo,
as long as the numbe
My recent PC runs Win 2000 Server edition. I have two 9i Rel 2 databases running on it
with no problems thus far.
In the past several weeks (since I got it), it has not booted by itself. But my NT 4.0
Server (3 years old now), did that twice, in the middle of the night, when no one was
watching
Hello Listers,
Anyone used this tool? What was your experience like?
I am planning on using it to move about 20GB of data from a Sybase 11.x database to
Oracle 8i (Rel 3). This is a one time activity. Flat file route (using Sybase 'bcp')
is the alternate solution. I would like see if we could
I can think of 8.1.3.
- Kirti
-Original Message-
Sent: Wednesday, February 05, 2003 6:04 PM
To: Multiple recipients of list ORACLE-L
What was the first version of Oracle with the ability to start
multiple archiver processes?
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
--
Title: RE: How to create a new oracle database from SVRMGRL??
If I may be so bold as to add a few details
on a UNIX server you can just fire up sqlplus (or svrmgrl for older versions of Oracle) and issue the create database statement.
On a Windows server you must first create the service with
Title: RE: another possibility for running Oracle / UNIX at home
UNIX is dead? Why does no one tell me these things?
BTW the link I meant to send is this:
http://www.macdevcenter.com/pub/a/mac/2003/01/03/oracle_part3.html
Part 3 goes into the gory details of what is needed for the install.
>
Sundeep - Have you tried other hints, like FIRST_ROWS? Or are you trying to
avoid hints entirely?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, February 05, 2003 5:30 PM
To: Multiple recipients of list ORACLE-L
Oracle 8.1.7.4 on HP-U
hi all,
how I know where the log directory in oracle
on redhat 7.3 ?
because I have a problem with my server, I was
installed redhat 7.3 and oracle 9.0.1 in Dell Power 2650. but after 2 week I get
a problem is the computer "HANG".
anyone can help me..
please I very appreciate
Regards,
We are considering implementing a SAN,
using Sun StorEdge SS9970 [OEM from Hitachi], where database
servers will be a mix of Sun Solaris and HP HPUX
running Oracle 8i, 9i, 9iRAC [in phase-2].
As the database files will be on File Systems [Sun or HP],
the solutions provider says that backups of th
Mogens,
Dick is right. Metalink Note 74988.1: "LogMiner analyzes redo log files from any
version 8.0 or later database that uses the same database character set and runs on
the same hardware platform as the analyzing instance"
Rgs,
Leng.
---
From: [EMAIL PROTECTED]
Date: Tue
Not in
a production environment, but I have been using VMWare Workstation since 2.0
with Oracle
as my
test, development platform. I run various Linux (RH, SuSE) with
Oracle without much problems.
I have
found occassionally simutanously start Opera and VMware cause my machine to
freeze.
Sundeep,
Have you reviewed Tim Gorman's paper titled: 'The Search For Intelligent Life In The
Cost-Based Optimizer'? Check it out at http://www.evdbt.com. It may help.
- Kirti
-Original Message-
Sent: Wednesday, February 05, 2003 5:30 PM
To: Multiple recipients of list ORACLE-L
Ora
Hi Roland,
I make a little modification to your query below,
SELECT distinct PBK.VARUKORGEANREL_ULAG.ean, 0, 0, 0,
rik2.vare.varenavn, rik2.vare.str,
PBK.VARUKORGEANREL_ULAG.lagstapris,
rik2.vare.hylletxt2, rik2.art_hierarki.vgrp, rik2.hierarki_tekst.
Title: windows application to show sql being executed by a client program
Hello list members.
A colleague of mine has written a small Windows client utility that allows you to view the SQL statements being issued by another client application. The utility has to be running on the same machine
Stephen - I appreciate your comments. One of the hard things for me to
understand is that if you're going to be working on W2K, better plan on
being the administrator. At Unix sites we tend to have DBAs supported by sys
admins. Some shops may indeed treat W2K that way. But usually if you are
always
Jeff,
If you see the SEQ# field in the v$session_wait view not incrementing, then something
else, other than Oracle, is causing a hang up...
On AIX, if you have AIO enabled, try running 'aiostat'. It will show if there are any
pending AIO requests. The difficult part would be to relate those p
Oh yeah, the thing I hate most about Windows as a server.
Try to do remote administration from any machine regardless of the OS.
Richard Ji
-Original Message-
Sent: Wednesday, February 05, 2003 5:42 PM
To: Multiple recipients of list ORACLE-L
> -Original Message-
>
> As much a
Hi Sesi,
Have restart your Oracle ?
Rgrds,
Sony
> -Original Message-
> From: Sesi Odury [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, February 05, 2003 9:53 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Drop datafile.
>
> Hi,
>
> I restored the database from cold backu
Hmm... there was nothing in that attachment... :(
When I did this, I followed the Migration Utility Guide. Those steps always worked...
:)
- Kirti
-Original Message-
Sent: Wednesday, February 05, 2003 3:59 PM
To: Multiple recipients of list ORACLE-L
Wow, never thought I'd see a requ
What was the first version of Oracle with the ability to start
multiple archiver processes?
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jeremiah Wilton
INET: [EMAIL PROTECTED]
Fat City Network Services-- 8
All,
I was wondering if anyone has any experience (good or bad) with the use of VMware on Oracle database servers? I am hearing rumors within my company that management is looking to utilize VMware to consolidate our WindowsNT/2000 database servers (test, development, and production). At this poin
Title: RE: Hanging query puzzle
Jonathan, Charlie, Denny: Thanks for the replies. Our SA's claim that there's
nothing wrong with the EMC SAN/disk. Finally, made them give me errpt access (they
had shut off execute privs from all but them) and got a lot of output like below.
The SAs
Oracle 8.1.7.4 on HP-UX
I am using collections to pass multiple values from client to the
database to gather values for more than input values. The queries
produce the results but the without the RULE hint the response is
dramatically slower. Following is just one of the examples but I have
many m
Thanks. Didn't know that. See you in Dallas next Sunday ;)
Regards,
Denny
Quoting Jonathan Lewis <[EMAIL PROTECTED]>:
>
> Just a warning for the future - this is no longer true
> on all versions of Oracle 9 because the wait_time
> column is a copy of the underlying x$ timing
> column rounde
> -Original Message-
>
> As much as I hate defending Windoze, Win2k is in fact rather stable,
> at least Win2k server is. I have one system on Win2k that I reboot,
> oh, every 6 months or so.
>
> Death to NT though.
>
The biggest problem that I have seen is (to me anyway) not one of s
Wow, never thought I'd see a request like this. :)
Nothing wrong to ask though, who knows, someone here might
have the time and resource to do it.
Let me know the kind soul who will do this. I have a list
of my own test to give out.
:)
Richard Ji
-Original Message-
Sent: Wednesday, Feb
Right. Sorry for the misnomenclature. Whoops, that's not actually a word.
:) I associated "raw" with "FS", instead of "volume". My faux pas.
I wanted to determine the need for RHAS for a test setup, and if there were
any differences in the RHAS' purchase levels that would affect a production
b
Too easy ;)
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )
UK___March 19th
USA_(FL)_May 2nd
Next Seminar dates:
(see ht
Take a look at this link, it might be helpful...
http://portal1.legato.com/resources/whitepapers/W012.pdf
Robert
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 2/5/2003 2:16 PM
I am considering doing an rman to disk backup and recovery solution for
a
500G-- grow to
Using pl/sql convert long column to clob and then use
dbms_lob.get_length().
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
Dennis,
Vsize does not like longs!!
Dick Goulet
Reply Separator
Author: DENNIS WILLIAMS <[EMAIL PROTECTED]>
Date: 2/5/2003 11:29 AM
Ed - Look up the function VSIZE in the documentation.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PR
This is for LONG. For LONG RAW, you could use utl_raw.length
or use a C or Java program to read it and calculate the length.
CREATE OR REPLACE FUNCTION l_length(cTabName varchar2,
cColName varchar2,
cRowid varchar2)
RET
Oops, my bad. Well I have limited experience with longs because I hate them
with a passion. Whenever one of the developers says they are going to use
long, I say "not on my database". You people are only making me feel better
about that philosophy.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAI
Is this all live OLTP type data, or might some of the data be made
read-only? How much will the data be growing and changing (if not a great
deal then look into incrementals). I can't begin to guess at the time
required those numbers are all factors of:
1. # of backup devices you will be backi
Damn, nothing like a dead OS that refuses to stay down!!
Dick Goulet
Reply Separator
Author: [EMAIL PROTECTED]
Date: 2/5/2003 12:54 PM
Very cool! I was wondering about this the other day.
See: http://www.oracle.com/start/apple/intro.html?src=14390
Title: RE: Size of a Long Field
I have this code that is used to search within a trigger body ... you can maybe adapt this to get length ... you have to just change dbms_lob.instr to dbms_lob.getlength() maybe.
CREATE OR REPLACE FUNCTION long_contains
( row_id ROWID,
VALUE VARCHAR2) RETURN NU
As much as I hate defending Windoze, Win2k is in fact rather stable,
at least Win2k server is. I have one system on Win2k that I reboot,
oh, every 6 months or so.
Death to NT though.
Jared
"Bernardus Deddy Hoeydiono" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
02/05/2003 12:48 AM
Pleas
Brian - Hopefully Robert will have a chance to respond to your question, but
if I might make some suggestions, I think your recovery time has two
components:
1. If the backup files are not on disk, the time to locate the tape, load
the files.
2. RMAN recovery time. I think you will just have to
There is a script (last updated Nov 2000) on my
website that gets you part way. But there is no
way you can find out about the contiguity of free blocks
(at least not the ones below the HWM) as you have
to walk every freelist to find all the free blocks, then
sort them into physical order. It i
You will only know what your system is capable of
It is very dependant on the disk arrays and no of scsi or fibre channels
you have to support those disks
Also RAID level will be a big contributor
How long does it take to copy say a 500MB file from location to location.
check it out this way
It looks like your process really is stuck
in a way that has nothing to do with the
Oracle code directly.
You might look at the CPU usage of your
session and its shadow using an O/S
utility, but I suspect it would show
zero CPU. Perhaps truss (or the AIX
equivalent) might show your process
spinn
Jeremy - I should probably have been more specific. :-) Years ago I worked
for a software vendor. They wanted to port their product to Oracle. They
expected to receive complimentary licenses in order to do this. Most vendors
bend over backwards to have you port to their product. Oracle expected tha
Windows is cheaper than SUN. Linux is cheaper than Windows.
Quoting Tony Johnson <[EMAIL PROTECTED]>:
> We have had an excellent experience with our Windows2000 clusters.
> Since moving to a clustered environment
> on our Test, Beta and Production systems over 18 months ago we have
> had 0 ( Zero
Do you mean something like this:
select max(bytes) from dba_free_space where tablespace_name = 'NAME';
> -Original Message-
> I would like to determine the maximum # of contiguous
> free blocks within an extent
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author
Unfortunately, I am not attending.
Having to choose between IOUG and HOTSOS, I opted for IOUG
as I haven't been since 2000.
I feel fortunate at that, as I know a number of folks that won't
be able to attend any conference this year.
Jared
Denny Koovakattu <[EMAIL PROTECTED]>
Sent by: [EMAI
Title: Partition and primary key
You need
to have 15 to 20gig temp space to do this, assuming you are
equipartitioning the primary key index.
-Original Message-From: NGUYEN Philippe (Cetelem)
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 05,
2003 6:53 AMTo: Multiple reci
Do Standby Databases & Database Replication come under the subject
"Reliability" ?
Yes, this would come under the topic of "High Availability"
Heres a ppt that might give you some more ideas:
http://www.darc.com/ncoaug/presentations/2001-summer/Bondra.ppt
HTH
Ed
-Original Message-
Dear List,
Life was pretty easy here before they came up with
this euro symbol :-( We had WE8ISO8859P1 (the default
I bevieve) as a char set on all Unix and MS (sorry we
have those as well) DBs accross the board.
That was also the client side char set (part of
NLS_LANG) - most clients here are on
Dennis,
PL/SQL cannot directly deal with longs > 32k.
There *is* a way to do with global temporary tables
and the to_lob() function, but it won't be nearly as
fast as just using 'copy'.
Jared
DENNIS WILLIAMS <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
02/05/2003 06:52 AM
Please respo
Hi Listers,
I've prepared a small list of steps to follow for
an upgrade of 7.3.4 database to 9.2
However unfortunately I do not have access to a 7.3.4 database
Can one of you who has access to 7.3.4 database, try these steps
out and give me your 'honest' feedback?
Thanks a lot
Cyril
Just a warning for the future - this is no longer true
on all versions of Oracle 9 because the wait_time
column is a copy of the underlying x$ timing
column rounded from microseconds to hundredths.
Hence the wait_time can show a zero when the
actual time is non-zero.
You should depend only on the
Stole right from asktom. Thanks Tom. :)
We do not build the result set anywhere in general.
If you do select * from one_billion_row_table -- we fetch the data from the
table as needed -- the results start coming back IMMEDIATELY not after we've
fetched the last row.
For certain types of queries
Does any have a script that shows actual # of used and free blocks in an
extent? I would like to determine the maximum # of contiguous
free blocks within an extent
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network
Very cool! I was wondering about this the other day.
See: http://www.oracle.com/start/apple/intro.html?src=1439096&Act=5
Developer's release of 9iR2 EE for MAC OS X.
Jared
Jacques Kilchoer <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
02/05/2003 11:30 AM
Please respond to ORACLE-L
OCFS = Oracle Cluster File System. An open source project lead
by Wim Coekaerts from Oracle. There is no such thing as raw FS,
it's just raw (without any file system). And I just learned about
this NBD (Network Block Device) from this list. So that's a third
option.
Richard Ji
-Original M
This command is used to put a datafile in recovery mode, not for
dropping the datafile. Now you either need to do recovery, or drop the
tablespace completely and re-create it.
Simply put, you cannot drop a datafile.
Suzy
Sesi Odury wrote:
>
> Hi,
>
> I restored the database from cold backu
Vivek
To me "reliability" means "won't break". Difficult to get hard data.
You might consider changing the name to "availability", which to me
covers not just reliability, but all aspects of my application being
available to my users. Things like dynamic parameters can be very important
becau
> I am attempting to RTF google on this
RTFG?
Yeah, I like it. ;)
Jared
"Sarnowski, Chris" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
02/05/2003 08:33 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subje
What is the exact error message, including text?
It could be failing on the temp segment initially created in
the index tablespace, and not necessarily running out
of sort space.
Jared
"NGUYEN Philippe (Cetelem)" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
02/05/2003 06:52 AM
Please re
If I try to connect to a database from server a to server b using sqlplus
and a database link and that database does not exist the connection attempt
seems to hang. Is there a way to set the timeout so it will not hang?
R. Smith
If you are not the intended recipient of this e-mail message, any u
Did you try tracing it from the OS ? Any error messages in the OS system
log ? Is it always one datafile/mount point ? A while back, I had seen a
similar problem when an array had gone bad. You may want to try using "dd" to
read and write some files and check the timing.
Regards,
Denny
Quo
Not easy. If your LONG is shorter than 32767, then you can, in a PL/SQL
function, fetch it into a VARCHAR2 of this size (allowed in PL/SQL) and
aplly LENGTH() to this VARCHAR2. Assuming the suitable Oracle version, I
think there is somewhere a function to convert LONGs to CLOBs - to which
you can a
Dennis,
Using VSize on a Long results in:
ORA-00997: illegal use of LONG datatype
Just tried in on Trigger_Body in DBA_Triggers. (8.1.7.0.0 on HP-UX).
Jack C. Applewhite
Database Administrator
Austin Independent School District
Austin, Texas
512.414.9715 (wk)
512.935.5929 (pager)
[EMAIL PROT
i was successfull in connecting to a Non oracle database from Oracle on unix
through the Listener on Win NT.
this situation arose b'cos we did not have a ODBC setup on Unix.
So we had to do the ODBC as well as the Heterogeneous services setup on Win
NT. and then try to connect from databse on Unix
Paul Baumgartel wrote:
>
> When one executes a query, the result set is identified. Fetching the
> rows in the result set can be done over a period of time. In what form
> does Oracle maintain the result set, and where?
>
> TIA
>
> Paul Baumgartel
>
If I understand well your question, I don'
DENNIS WILLIAMS wrote:
>
> Maria - Actually, I would think the best time to contact Oracle sales is
> when you don't have money. Good sales people can smell money. ;-)
>Some software companies are very liberal about providing their product
> for development and training purposes. My impression
Hi:
I am trying to understand why sqlplus did not display stats when I run
"analyze table ..." and "create index ..."?
TIA.
Guang
--
SQL> set autotrace on statistics
SQL> analyze table gene_upr compute statistics;
Table analyzed.
SQL> desc gene_upr;
Name
Ed,
Perhaps you could use the DBMS_SQL Define_Column_Long and Column_Value_Long
procedures to manipulate the Long?
Converting the Long to a LOB using To_LOB function, then manipulating it
with the DBMS_LOB package might do, too.
Jack C. Applewhite
Database Administrator
Austin Independent Schoo
Title: RE: How to dump UGA ??
KG,
That's what I am looking for ... which sessions have trace enabled ...?
Developers *forget* to disable tracing in their code when they move it to production ... so I have to investigate ...
Raj
__
Rajendr
Markus - That is what I call a creative solution! I'm no lawyer either, but
excellent!
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, February 05, 2003 9:34 AM
To: Multiple recipients of list ORACLE-L
Did you ever consider that your (
Ed - Look up the function VSIZE in the documentation.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, February 05, 2003 8:53 AM
To: Multiple recipients of list ORACLE-L
How do you determine the size, in bytes, of a long field?
Title: RE: Hanging query puzzle
Still sitting there, while we try to figure out exactly why it's waiting.
SID Username EVENT WAIT_TIME STATE SECONDS_IN_WAIT
-
Title: another possibility for running Oracle / UNIX at home
A few days ago someone had asked about what options are available for running Oracle (database) on UNIX at home.
I just saw this article:
http://www.macdevcenter.com/pub/a/mac/2002/11/12/oracle_part1.html
Installing Oracle 9i on Mac
Create the new table, and then use the sqlplus 'copy' command,
as it can handle longs.
Jared
On Wednesday 05 February 2003 02:23, BanarasiBabu Tippa wrote:
> Hi everyone
>
> One of my development team is working on ORACLE 8 on NT (Because of client
> requirement they are working on that version)
What is the value for WAIT_TIME ? This may not be an IO problem
if 'WAIT_TIME' is not 0. A session is waiting only when 'WAIT_TIME' is 0. I
would suggest running some utility like tusc (HP), truss (Sun), strace (Linux)
and check it from the OS side. Since this is a third party tool, it could
Did you ever consider that your (prospective) trainig candidates get the (for testing
purposes freely downloadable) oracle software themselves and install it themselves (or
assisted by you) on a good (linux - one might hope ;-)) box and then you assist them
by getting along with this?
I think
Roland,
A quick look suggest you have cartesian joins unless rik2.vare,
rik2.hierarki_tekst, rik2.art_hierarki, pbk.sortiment_vgrp all have only one
row.
Iain Nicoll
-Original Message-
Sent: 05 February 2003 14:53
To: Multiple recipients of list ORACLE-L
I have this sql query. I am w
Sorry, running 8.1.7.2 on AIX
4.3.3.
-Original
Message-From: John Shaw
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 05,
2003 2:09 PMTo: Multiple recipients of list
ORACLE-LSubject: Re: Hanging query puzzleWhat version
are you running - I have a similar problem on 9.
I am considering doing an rman to disk backup and recovery solution for a
500G-- grow to 1terabyte
database. Monster HP servers ... up t0 16 cpu, upto 10,000 concurrent users
This rman would be the secondary recovery solution (Timefinder is the
first).
Anybody know time frames I might be ab
Title: RE: Oracle License for Training
> From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
>
>
> Maria - Actually, I would think the best time to contact
> Oracle sales is when you don't have money. Good sales people
> can smell money. ;-)
Heh.
> Some software companies are very lib
Title: Message
Man,
what a buzz-kill you are.
-Original Message-From: Ed Bittel
[mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 05, 2003
6:53 AMTo: Multiple recipients of list ORACLE-LSubject:
Size of a Long Field
How do you determine the size, in
bytes, of a
List,
I have a developer that I want to grant access to change another schema
owner's packages in TOAD. I have granted connect, resource, and roles which
incorporate DML on the tables and execute on the packages. When he goes
into TOAD he can see the package spec but not the package body. How d
What version
are you running - I have a similar problem on 9.2.0.2 on Solaris 9 that I've had
an open tar on since November - Support has finally called up and said other
people are having the same kind of problem - especially in regards to parallel
processes. I am supposedly getting a test
Maria,
You found the fly in the ointment. Since training is your business then you
end up paying for the software just like the rest of us. Now if your doing
training in-house, for your own company, then things are different.
Dick Goulet
Reply Separator
Title: RE: 9i "Reliability" means ?
Reliability would have to include Standby, Data Guard, RAC - pros/cons of all and when you might use one versus the other. Also, go to the Freeman book as a start on new options and look through the new features and decide what could lead to more "reliable"
Jonathan:
How about calling the DBMS_SYSTEM.READ_EV procedure?
I think this is simpler than going to the UGA dumps..
THe restriction with DBMS_SYSTEM is, you can not get
the event settings of the other sessions. But Dumps
can.
Best Regards,
K Gopalakrishnan
-Original Message-
Lew
forgot couple things, add this database to your oratab and added it to
your tnsnames.ora
Joan Hsieh wrote:
>
> Majid,
>
> 1. Create ini.ora, link this ini.ora to your oracle_home/dbs
> 2. startup nomount pfile=$ORACLE_HOME/dbs/initestdb.ora
>
> create database TESTDB
> maxdatafiles 1021
There is no "join" condition between first two tables (PBK.UNDERLAG,
PBK.VARUKORGEANREL_ULAG) and last four tables (rik2.vare,
rik2.hierarki_tekst, rik2.art_hierarki, pbk.sortiment_vgrp).
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE
Majid,
1. Create ini.ora, link this ini.ora to your oracle_home/dbs
2. startup nomount pfile=$ORACLE_HOME/dbs/initestdb.ora
create database TESTDB
maxdatafiles 1021
maxinstances 1
maxlogfiles 8
maxlogmembers 4
character set WE8ISO8859P15
datafile
'/testdb/sy
Try
this,
Select
table_name,column_name,data_length,data_type
from
dba_tab_columns
where
owner = ''
and
data_type='LONG' ;
--
Babu
-Original Message-From: Ed Bittel
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 05, 2003
6:53 AMTo: Multiple recipients of li
Sony,
Don't you mean Database Configuration Assistant? Not only does it create
the database, but configures the listener as required and the registry.
Dick Goulet
Reply Separator
Author: Sony kristanto <[EMAIL PROTECTED]>
Date: 2/4/2003 7:08 PM
Title: RE: HPUX SCSI Performance
HPUX 11i version 1.6 for itanium on vxfs
-Original Message-
From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 05, 2003 12:14 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: HPUX SCSI Performance
What OS? What filesyst
1 - 100 of 148 matches
Mail list logo
