If PreCompilers were installed, check in $ORACLE_HOME/precomp/lib* directories.
Also, check your path, ld library path.
Here's what I get (9iR2 on HP-UX).
/u01/home/oracle/product/9.2.0
hp102 [KED9]: find . -name libproc2.a -print
./precomp/lib32/libproc2.a
./precomp/lib/libproc2.a
- Kirti
Connor,
I seem to think otherwise. Storing 100 GB of image is not necessarily a
pretty proposition either when you consider hot backups and archived log
generation, etc. I presume you are concerned about the management of the
image files considering the sheer volume of it. But that's precisely wha
Ron,
Good idea, but DEGREE=1
There are two indexes, but they are in a different tablespace (which has
plenty of free space available and did not give an error).
Next extent size is 25M but, as mentioned, it shouldn't have needed a new
extent.
I'm still at a loss...
Jay
-Original Message--
Hi, all,
My developer continually got ora-1722 when he was installing a new billing
system. I used 10046 event to get trace file, but i could not figure out
which bind variable value causes the error, here is the part of trace:
PARSING IN CURSOR #1 len=229 dep=0 uid=62 oct=2 lid=62 tim=807252370
installed O92010 on rh 8.0. went fine so far until I tried to connect via "oemapp
console" - whatever connectdescripter I chose in resulted in the error "string not
properly terminated". same connect descriptors in the CLI worked fine - made them
available in the "oemapp console" and got the err
John ,
I meant the same param.apologies ,i misplaced db and create. Is this
parameter obsolete (with 9i) coz its not mentioned in the Documentation
(9i) list of initialization parameters. Only db_create_file_dest is
present in the doc.
Thanx !
best regards
Tc
On Tue, 3 Dec 2002 [EMAIL PROTECTED]
Its in the 9.2 doco
hth
connor
--- "Tinu !@#!^%" <[EMAIL PROTECTED]> wrote: > Hi
!
>
> I 've a question regarding OMF realted parameter
> CREATE_DB_ONLINE_LOG_N. Now y is'nt this parameter
> mentioned in the list of parameters in the Oracle
> Documenttion cd of 9i. Is it obsolete or oracle does
Managing 20mil of anything (images/text/etc) in a file
system isn't a nice proposition. Go with the database
hth
connor
--- oraora oraora <[EMAIL PROTECTED]> wrote:
> Guys , i posted this already and this time my
> question is a bit
> different .
>
> I have to store 20,000,000 images of 5k
There is a OMF related parameter called db_create_online_log_dest_n.
This defines where the online redo logs are created. The value n can vary
from 1 to 5 and it allows for upto 5 multiplexed copies opf each redo log
group member.
HTH
John
-Original Message-
Sent: 03 December 2002 11:
I posted a similar question recently and whilst I received some answers I
never did discover an exact way of matching oracle use of memory with unix
use of memory.
One issue is that when oracle releases memory the unix process does not
automatically do the same until the memory is required. Therefo
HELP
Must..
resist urge...
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Tinu !@#!^%Sent: 03
December 2002 11:29To: Multiple recipients of list
ORACLE-LSubject:
HELP
I don't know whether people do it on purpose or they are still unaware
after so many similar postings of the same nature and replies of 'ARE YOU AN
IDIOT', but it does result in a plethora of responses which create unnecessary
hassles.
Jared, why not parse messages for these commands and se
Mark,
yes, I'll be there and Monday night is fine. I don't know the area at all so
can't suggest venues but I'm not choosy regarding food so anywhere should do
for me.
Cheers,
Mike
-Original Message-
Sent: 03 December 2002 09:59
To: Multiple recipients of list ORACLE-L
Hi All,
I remem
Ora-472 is a very non-specific PMON error. You've probably already worked
through this with support using a TAR, but if you still are having problems and
wanted to post the following it would help:
The stack trace from your pmon traces (they'll either be in bdump or udump, and by
stack t
Hi !
I 've a question regarding OMF realted parameter
CREATE_DB_ONLINE_LOG_N. Now y is'nt this parameter mentioned in the list of
parameters in the Oracle Documenttion cd of 9i. Is it obsolete or oracle does
not recommend it's use.
regards
Tc
chao_ping,
It seems i am posting a too long question, so nobody is interested.
I post the answer to my second question, to check the memory
utilization in linux operation system.
It is in /proc/spid/status file.
Regards
zhu chao
Eachnet DBA
86-
I'm up for a drink - I think we all deferred to your
local knowledge. I say choose a pub and anyone thats
want to be there simply rolls up when the free beer
the exhibition hall dries up. (I'm guessing around
7pm)
Cheers
Connor
--- Mark Leith <[EMAIL PROTECTED]> wrote: > Hi
All,
>
> I remembe
Count me in on this, Mark -
As for a 'table' - presupposes a venue in which to find said article of
furniture...(!) no idea on that, but there are places out the back of the
ICC as I recall which might be suitable.
peter
edinburgh
> -Original Message-
> From: Mark Leith [mailto:[EMAIL P
Guys , i posted this already and this time my question is a bit
different .
I have to store 20,000,000 images of 5k each either in DB ( on
win2k) or linux o/s file system.
the images are to be displayed over mobile phones.so the time to
retrieve the images should be minimum.
for this to be
Some simple options:
1) The 9.x installer still gives the option of
creating scripts in the old fashioned way. The key is
not to choose a "template" database. A little
scrubbing and they work fine...but man do they take a
while to create a db nowadays.
2) My preferred option is to create a skel
hello to everybody
I'm desperately looking for precompiler e.g. proc in the installation of O 9.2. can't
find libproc2.a is the message when I try do creat. doesn't seem to be an installation
issue, because no kind of installation offers the(se) file(s).
precompilers did exist in 9.0.1 - but th
>
>Hi All,
>
>I remember that a number of people were all for
>getting together on the
>Monday night at the UKOUG. I *don't* remember us
>actually arranging a
>place/time.. ;) Is there any chance of another show
>of hands so that we can
>see if we'll need to book a table or not. And has
>*anybody*
There are issues here. Will the table being copied to have the same
constraints in place as those tables from which the data is being extracted?
If so, resolves those, and get these reference tables in place first.
Then simply use a database link to 'pull' the data from your source tables,
eg
ins
Yup, got that covered :)
If I may add another point. When dealing with SLA's, you not only have to
"show" that the database has been servicing users that are connected
(showing database uptime), but also that users can also *connect* to the
database as well (the listener is servicing requests).
I
Hi All,
I remember that a number of people were all for getting together on the
Monday night at the UKOUG. I *don't* remember us actually arranging a
place/time.. ;) Is there any chance of another show of hands so that we can
see if we'll need to book a table or not. And has *anybody* had any thou
hi gurus!
can anyone answer this (maybe newb question:)
i have a table with a BLOB column. this table is stored in a
seperate tablespace, in which there are no other data than that
of this very table.
suppose now i have one row in this table.
if i delete this row, the blob is also deleted an
101 - 127 of 127 matches
Mail list logo