You should run nm command to verify whether shr.o exists. I think that is
something like this:
/usr/ccs/bin/nm libclntsh64.a | grep shr.o
And then if it exists, you must verify whether executables are dynamically
linked with dump command.
Regards.
-Mensaje original-
De: [EMAIL
HI JOHN,
What exactly the error.Please be more specific.Was the MV created. Or after
creation of MV after some interval (The interval specified while creating MV)
you didn't see the refreshed data.I suppose that must be so..
Check Job_queue_processes,Job_queue_interval parameters in your
Thanks a lot to all who have responded !
U guys really give me inspiration and motivation to go ahead and learn
things .
I decided to learn everything i could about Oracle ( mainly from these
lists ) and simultaniously epand my Java experience .
I think it's a good path !
Thanks a lot again for
Try do download the files when all those Californians are still in bed, they
tend to clutter up the 'net.
= : ^ o
Also, what OS are you running? I find that on my old PC clone at home,
Windows95 sometimes corrupts downloads if I tell it to ftp down a file and I
keep surfing the net with IE.
Then everybody will use the one that's left.
[EMAIL PROTECTED] 03/02/01 11:45PM
Hi,
Anyone have idea, how Oracle8i make used of multiple rollback segments to
reduce system contention?
I am currently using 4 rollback segments what will happen if 3 of them are
offline?
:(
Thanxs,
--
Just ignore this error message. It just means that the script's trying to
create a role that already exists. You'll get some like this when you re-run
your catalog.sql, etc.
HTP.
Gunawan Yuwono
--- [EMAIL PROTECTED] wrote:
Hi guys,
I am using sys account to run catexp.sql there is an error
Hi,
http://osi.oracle.com/~tkyte/article2/index.htm
I tried that link, I am sorry but I forgot the right source for it.
a)Although I do have few more resources, which are good examples for
application contexts. This one works.
http://www.akadia.com/services/context_example.txt
b)Also try,
Maestros I've got some questions.
(1) There was a schema dropped on one of the databases, some where
around November 2000. Now another lady was working on it, she never up
with any positive result and eventually she left the Company, now they
are saying I must take over. The actually thing is
Just saw this note posted this morning for all that are interested.
Subject:
Goodbye to all that
Date:
Mon, 5 Mar 2001 22:20:02 +1100
From:
"Howard J. Rogers" [EMAIL PROTECTED]
Organization:
CWO Customer - reports relating
The error happens on the create statement. The sql works fine if the MV is is the
same instance. As soon as I try to create the MV on seperate
instance thru a link , I get an ORA-12054: cannot set the ON COMMIT refresh attribute
for the materialized view.
[EMAIL PROTECTED] wrote:
HI
Title: RE: RE: eek! completely off topic
Ruth,
You are most welcome! Glad you found it of use.
Most interesting to me in particular was the bit
about BSE. Fascinating, really.
It's been on the site for almost a year, but the
news that this could be about organophosphate
blood
Hi guys,
1. In my Oracle I have accounts : - teddy/bear (normal user can create)
- sun/solaris (granted DBA role)
2. I run the catexp.sql using sys account (just one error occur
IMP_FULL_DATABASE confilct)
3. TEDDY created a table EMP with 7 records
4. I am
It depends if the are public access or private.
Bottom line if you were using them actively, you will slow down since it
is likely the remaining segment will have to issue quite a few more extents
to keep up with activity.
Tim Sawmiller wrote:
Then everybody will use the one that's left.
The database is Oracle8.1.7. I used the syntax:
alter table foo drop column bar;
Why it gives run out of RBS error? Is alter table a
DDL? How does it use RBS?
TIA
Chris Harvest
__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
You cannot issue a startup command as any user except internal or / as
sysdba. The password file has to be invoked before you can use it and it is
invoked on startup.
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Sunday, March 04, 2001
We won't hold it against you. :)
Dan 'tried procedure builder, but found look and hack worked better'
-Original Message-
Sent: Sunday, March 04, 2001 10:00 PM
To: Multiple recipients of list ORACLE-L
I'm sorry to admit it, but I find Procedure builder that comes bundled
with
I believe the SHOW=Y parameter is causing the problem. That does not do an
import but rather lists the table/index/grants etc details held on the
export.dmp
REmove that parameter and try the fromuser to user parameters or the full =y
parameter
John
-Original Message-
[EMAIL PROTECTED]
Set IGNORE=Y, SHOW=N in your import parameters. The table already exists,
so you need to ignore errors, otherwise it won't import the rows. SHOW=Y
will only list the contents of the export file, so it needs to be set to N
(or not set it at all) so the rows will be imported.
I would use care
Oracle V8.1.6.3 on Solaris 8
oracle@callisto:/u01/app/oracle/admin/CCC/pfile:362 oerr ora 1925
01925, 0, "maximum of %s enabled roles exceeded"
// *Cause: The INIT.ORA parameter "max_enabled_roles" has been exceeded.
// *Action: Increase max_enabled_roles and warm start the database.
OK,
Say ignore=y and rerun it.Because when you say ignore=n it sees the table_name
alraedy exists
So either drop the table and rerun the import again (the same you were using)
Or say ignore=y that'll set all things right
Cheers
Ganti
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
Thanks everyone.
I managed to install it, the trick was to use Typical, and avoid Custom
installation. (Resist, Pat! Resist! Don't press that button! Your life
will be ruined! Pestilence on your family if you press that button! --
Self-destructing software, pits and traps for the unwary,
Would someone tell me if Oracle 8.0.5 will work with Windows 2000?
TIA
Matt
--
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-- Public
Hi john,
Did you check the parametrs right.And any event parameter in your init.ora file
Check and reply soon
Chhers
Ganti
--
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
Title: RE: No record in import help me please :..(
take out
SHOW=Y
it does just that: only SHOWs what it would do, does NOT do it.
:-)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 05, 2001 9:45 AM
To: Multiple recipients of list
At least you're going to have a job!
-Original Message-
Sent: Monday, March 05, 2001 10:41 AM
To: Multiple recipients of list ORACLE-L
I asked for the salary, benefits, flex time, relocation etc.
And guess what!
There is no reply.
- Kirti Deshpande
Verizon Information
To ALL, For your edification, or whatever!
Dick Goulet
Forward Header_
Author: ESSRV_us [EMAIL PROTECTED]
Date: 3/5/2001 9:30 AM
Hello,
Metalink has been experiencing intermittent difficulties with login issues
due to some unforeseen technical
I asked for the salary, benefits, flex time, relocation etc.
And guess what!
There is no reply.
- Kirti Deshpande
Verizon Information Services
http://www.superpages.com
-Original Message-
From: Boivin, Patrice J [SMTP:[EMAIL PROTECTED]]
Sent: Monday, March 05, 2001 6:46
For ALL download needs I use Download Accelerator Plus available free from
http://www.speedbit.com
This supports downloading the same file from multi-mirrors at the same time,
resuming downloads, auto-dial, schedule, auto-drop connection, shutdown, and
speeding up your suck it through this
You need to add
FROMUSER=TEDDY
TOUSER=TEDDY
to your parameter file and try again.
[EMAIL PROTECTED] wrote:
Hi guys,
1. In my Oracle I have accounts : - teddy/bear (normal user can create)
- sun/solaris (granted DBA role)
2. I run the catexp.sql using
Hi ,
thanks for the tool.
VGN
--- [EMAIL PROTECTED] wrote:
Hi Venu!
I'm offering a very simple shareware
PL/SQL Debugger that allows you to send
messages from your PL/SQL code on the
fly to a simple GUI interface.
Have a look at it at:
http://www.materialdreams.com/products.html
It is static. It happened to me on Version 8.0.6, I increased the number
of max_enabled_roles in init.ora file and bounced the DB.
HTH
Robin
Charlie Mengler wrote:
Oracle V8.1.6.3 on Solaris 8
oracle@callisto:/u01/app/oracle/admin/CCC/pfile:362 oerr ora 1925
01925, 0, "maximum of
Use the TABLES=(teddy.emp) and FROMUSER=teddy, TOUSER=sun parameters in you
import parfile. This should do it.
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Monday, March 05, 2001 9:45 AM
Hi guys,
1. In my Oracle I have accounts : -
Probably to undo the changes in system tables (extents, etc.)
-Original Message-
Sent: Monday, March 05, 2001 11:10 AM
To: Multiple recipients of list ORACLE-L
The database is Oracle8.1.7. I used the syntax:
alter table foo drop column bar;
Why it gives run out of RBS error? Is alter
Yeah, Its simple the two paramets giving you trouble!!
show=y (it won't import any thing, It just show you it can work or not!!)
destroy=y(Once you imported it, It will destroy the data of that copy)
That is reason you can see the skipping...due to show=y
Raghu.
From: "John Hallas" [EMAIL
Actually, when I was in a Forms environment it was my
tool of choice as well. I would actually develop in TOAD
but if I hit a compile error that I could not easily figure
out I compilied it in Procedure Builder and usually found
it right away.
-Original Message-
Sent: Sunday, March
When you use show=y, you're just listing the tables in the dump file.
Either set this to N, or leave it out of your parm file. (N is the default)
imp help=y will also tell you this.
Hope that helps
Patrick Prince
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
Set IGNORE=Y, SHOW=N in your import parameters. The table already exists,
so you need to ignore errors, otherwise it won't import the rows. SHOW=Y
will only list the contents of the export file, so it needs to be set to N
(or not set it at all) so the rows will be imported. Use the
Hey, I got one of those today as well. I wasn't
so nice in my e-mail to them though. What I like
is when I give up and phone the tar in and they
start with "Have you tried our Metalink...". I
have a real hard time playing nice then.
-Original Message-
Sent: Monday, March 05, 2001 9:36
International Manufacturing company in the Nashville, TN area needs a solid
Oracle
Financials DBA to join it's I.T. team.
The selected candidate also has the choice of working out of their Greenville
South Carolina office.
This is a full time staff position..no sub-contractors or third parties
For those interested, I found this on Metalink. It was posted this morning:
News Notes
MetaLink Performance - Status and Actions
My name is Tom Brennan, VP New Technologies and CRM deployment for Oracle
Support Services. As part of my
How are you connecting as? Who are logged onto the server as? RBG
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Saturday, March 03, 2001 12:55 AM
Hi all,
This is a special problem I am facing and hence I am not able to start my
database
Hi Friends
Does any body can shed light on Oracle Expert???
Thanks
Raghu.
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Try using FROMUSER/TOUSER when importing.
HTP.
Gunawan Yuwono
--- [EMAIL PROTECTED] wrote:
Hi guys,
1. In my Oracle I have accounts : - teddy/bear (normal user can create)
- sun/solaris (granted DBA role)
2. I run the catexp.sql using sys account (just
Not supported.
from MetaLink:
---begin excerpt---
Certify - Product Version and Other Selections: Oracle Server -
Enterprise Edition On Microsoft Windows 2000
General Notes For Oracle Server - Enterprise Edition On Microsoft
Windows 2000:
Shipping Information:
Starting
Hi there,
I'm new to Oracle, coming from (gulp!) Informix.
I hope to find on this newsgroup a great help from you.
(it was the case in the Informix newsgroup ;-)))
We are in the developing phase, and during tests,
our front-end application crashes often and our server
application who access
I have a java appliation which uses Oracle Thin driver
for 8.0.6. Some of the times it gives me error
ORA-17412 "Bigger Type Length Than Maximum" and
connection breaks up. It happens randomly..
Where can I get more details on it...And what should I
do to fix it..
Will appreciate any help!!!
Does anyone see error ORA-600 [19942] and ORA-600 [19944] when the user try
to make the function call: EMPTY_CLOB() in and update statement to
initialize the CLOB value?
Is it a bug?
Winnie
OS: Solaris 2.6
Database: 8.0.5.2.1
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Chris, be careful,
Truncate will kill all 9 million records - everything. Truncate acts
vertically. Drop column has very different effect :) Records a safe, but one
column is gone. It acts horizontally. Use set unused, if waste space is not
an issue.
Just my $0.02
Vadim Gorbounov
Oracle DBA
Title: exporting MDSYS schema from an Oracle Apps 11i database?
My commander-in-chief has told me that he wants a second copy of a sample Oracle Apps 11i database for use by developpers. Aye-aye sir I answered smartly and went on the hunt for an Oracle Apps 11i database that I got copy over.
Yeah, it works.
-Original Message-
Sent: Monday, 05 March, 2001 10:26 AM
To: Multiple recipients of list ORACLE-L
Would someone tell me if Oracle 8.0.5 will work with Windows 2000?
TIA
Matt
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET:
UNEXPECTED GROWTH?? How can they not expect growth when they force ALL
their TAR functions to be initiated via iTAR. As for acceptance of
Metalink, isn't that sort of like saying you can use Metalink for all your
support contacts or you can use Metalink. What choice did we have in
"accepting"
I agree with you, Rodd.
Ever since they force everybody to open the TAR in metalink, they should
expect a huge growth in the number of TAR submitted per day. Before they
introduce this function, in order to open a TAR, you probably have to wait
on the phone for at lease 30 minutes to open the
Position: Oracle DBA
Location: Richmond, Virginia
Description:
This position is with a major entity that needs an Oracle DBA
to provide database support. This is a staff position.
* Responsibilities:
The selected candidate will work under limited direction and perform
installation,
It has been decided from upon high in damamgement that a consultant company
WILL be installing an application s/w package produced by Siebel onto a
SUNW,Ultra-250 running Solaris 8 acquired specifcally host this application.
The system has 1GB RAM and a pair of mirrored (RAID-1) 18GB disks.
I am
Hi all,
Is there any way to know what sql statament a connection is currently
running.
My database 8.1.6.0.0 is suddenly causing our operation system (sun solaris
2.7) to
plunge into Swap. There are no other applications running on this machine.
I would like to know if I can look at what a
I'm following this thread and a worrying thought has crossed my mind:-
If Oracle carries on with this pricing model, soon we will all be looking
for a new job..scary :-)
Martin Kendall
-Original Message-
Sent: 02 March 2001 22:00
To: Multiple recipients of list ORACLE-L
Last
Title: RE: RE: eek! completely off topic
Yes..in the free-est country in the world, it
is amazing the restrictions we live under. :-)
-Original Message-
From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 05, 2001 4:21 PM
To: Multiple recipients of list ORACLE-L
Maestros I've got some questions.
(1) There was a schema dropped on one of the databases, some where
around November 2000. Now another lady was working on it, she never up
with any positive result and eventually she left the Company, now they
are saying I must take over. The actually thing is to
Ya. I just wanted to provide the specific URL to the (presumed)
BSE article you mentioned since it took me a couple of minutes
to dig it out, and I thought others interested would find it
convenient to just click, rather than search for it.
regards,
ep
On 5 Mar 2001, at 13:45, Mohan, Ross
Larry,
Try the following.
Regards,
Bruce
-- this one will be faster but only shows the first 1000 characters of the
SQL
select username, q.*
from
v$session s , v$sql q
where
q.address = s . sql_address
and q.hash_value = s.SQL_HASH_VALUE
and
Title: RE: RE: eek! completely off topic
It may
be great, but it does not site any sources. For all we know they are some
sort ofmarketing organization trying to manipulate public opinion.
They would inch up the credibility scale if the articles they have were
independently
verifiable.
Not so far fetched. My company lost several very large clients to DB2 and I am without a job.
Martin Kendall wrote:
I'm following this thread and a worrying thought has crossed my mind:-If Oracle carries on with this pricing model, soon we will all be lookingfor a new job..scary :-)Martin
Ruth to drop a column, use truncate?
Joe
Ruth Gramolini wrote:
Use truncate instead of drop. Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Monday, March 05, 2001 11:10 AM
The database is Oracle8.1.7. I used the syntax:
alter
Anyone use Oracle Fail Safe for NT? Compaq just finished a tech/mkt presentation and
made it seem oh so easy (for the right $). I am wondering if anyone has done it and in
a multi DB env.
Cheers,
Earl
Get 250 color business cards for FREE! at Lycos Mail
Hi, guys. I may need to implement OPS 8.1.7 on AIX/RS-6000 . I do not have
much experience with AIX. Most of my unix experience is on Solaris and I
have good understanding about OPS issues on Sun and Veritas clusters. Could
somebody give me some pointers - specics for AIX and RS-6000
Actually, the whole website is very interesting. RBG
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Monday, March 05, 2001 5:11 PM
Ya. I just wanted to provide the specific URL to the (presumed)
BSE article you mentioned since it took me a
Title: RE: exporting MDSYS schema from an Oracle Apps 11i database?
-Original Message-
From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]
Sent: lundi, 5. mars 2001 11:51
I know that there is an MDSYS schema (see results of SQL below) but export says
About to export specified
Yarg! Snarfle! Argh! (sounds of chewing up furniture) For some reason, I can't find the URL that started this conversation. I thought it might be sales.oracle.com, but that doesn't give me the power unit calculations. Can someone help?
At 02:26 PM 3/5/01 -0800, you wrote:
Not so far
Title: RE: exporting MDSYS schema from an Oracle Apps 11i database?
-Original Message-
From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]
Sent: lundi, 5. mars 2001 15:46
Does anyone know if MDSYS is in fact the Oracle 8i Spatial functions
user and/or how I could create that user and
Title:
You should be able
to find it at:
http://store.oracle.com
Jeffery StevensonChief Databeast TamerMedical Present
Value, Inc.Austin, TX
-Original Message-From: Dennis Taylor
[mailto:[EMAIL PROTECTED]]Sent: Monday, March 05, 2001 6:01
PMTo: Multiple recipients of
This is an elementary q.
If i have a col of NUMBER data type what is the last number that can be
stored
in this col.
Ravindra
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ravindra Basavaraja
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
Hi,
I want to display thedata fromfew
tables into Excel sheet. How do I do that?
Is there any tool available?
Sanjay
Hi All,
I'm getting this following error, when I run my
report in Report Designer 2.5.7.4.3 and click "last"
button.This error never appears on any my reports
last
month, but now it occurs on some of my report.
Appreciate any help.
Thanks,
John.
Henry,
set the following parameter in the sqlnet.ora on the server and not on the
client.
the unit is minutes. 10 mins shld be enuf. test with ur environment. if set
less then maybe it may hv an impact on SQL*Net performance.
SQLNET.EXPIRE_TIME= 10
-Mandar
-Original Message-
thanks for your concern pals,
Off course i've been installing the software (precompiler) also
I've been doing :
-- $proc iname=sample1.pc oname=sample1.c or even
-- make -f demo_proc.mk build OBJS=sample1.o EXE=sample1
result is still the same :
make: *** [sample1.o]
segmentation fault (core
Hi guys,
I'm a beginner in Oracle.
When I try to startup database via SVRMGR , there's error :
"can not mount database Exclusively"
Anybody knows why this thing happen ?
How you fix it ?
Thanks in Advance :)
Bambang Setiawan
--
Please see the official ORACLE-L FAQ:
Hi
Sanjay!
You can
usethe shareware tool TabExp to generate
Excel
compatible CSV
Files.
http://www.materialdreams.com/products.html
Cheers
DO
Original
Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Sanjay KumarSent: Tuesday, March 06, 2001 2:40
AMTo:
Hi Larry!
You can use the shareware tool Top100 to dig
into the statements currently available in the
SGA and filter them by user.
http://www.materialdreams.com/products.html
Cheers
DO
-Original Message-
Taylor
Sent: Monday, March 05, 2001 10:58 PM
To: Multiple recipients of list
Hi,
See script 6 "Manage Oracle trace files (delete old/ send mail for
new)" at http://www.orafaq.com/faqscrpt.htm#UNIX
Best regards
- Frank
[EMAIL PROTECTED] 03/03/01 01:16
Has anyone written and is willing to share a shell which would:
find the list of .trc files, tkprof the files to
79 matches
Mail list logo