HELP
Hi,
Well, since I can't sleep, I may as well try solving a problem.
This is a bit odd, and I'm trying to think of the most efficient way to do
it. I've set up some bitmaps in my app. Consider we have documents that
we want to sell. In order to be able to sell a given doc, we need to have it
Any body having Oracle Dev/2000 6i CBT's .
If any Can you please send ?
Thanks in Advance ...
Kirtish P. Gaonkar
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Kirtish P Gaonkar
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
SET ORACLE-L MAIL
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Barry Deevey
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
Hello!
It's me else one :)
When I setup Email Notifications to sysman (sender's email, smtp server,
etc) it cannon send report to me cause of VD-4280 error: The SMTP Server
could not be connected to. Email server is working properly, configured too.
Mail client from the same machine works fine.
HELP
Esta mensagem, incluindo seus anexos, pode conter informação confidencial e/ou privilegiada. Se você recebeu este e-mail por engano, não utilize, copie ou divulgue as informações nele contidas. E, por favor, avise imediatamente o remetente, respondendo ao e-mail, e em seguida
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
HELP
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
SET ORACLE-L
DIGEST
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gene Gurevich
INET: [EMAIL PROTECTED]
Fat City Network Services--
Hello Experts,
I am using Jdeveloper 9i to make a simple Application which
reads data from a binary file and displayes it in a TextArea
or JTextArea. This application works fine when i run test
it through the JDeveloper 9i Environment. But when i deploy this
application into a JAR File -
help
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Benny Pei
INET: [EMAIL PROTECTED]
Fat City Network Services--
help
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Zhou, Tapiwanashe
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
SET ORACLE-L NOMAIL
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: James PEARSON
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
help
help
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: pfeffer
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
SET ORACLE-L NOMAIL
--
-
Software Engineering
Vattmannstraße 7, 33100 Paderborn
Phone: (+49) 52 51 / 30 1 6333
Fax: (+49) 52 51 / 30 16 399
eMail: [EMAIL PROTECTED]
http://www.unitrade.com
We have two servers: Server A running iAS ; Server B running IDS 9 and
serving files.
We map one drive from server B to server A and we are trying to access the
forms on the remote driver:
http://host:port/forms90/f90servlet?form=f:\form_name.fmx
But we receive an error saying that the servlet
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Radu Deliu
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
Hi,
I have been grappling with this for sometime
I have a table a_user_groups
USER_ID SECURITY_GROUP_ID GROUP_ID
-- - --
1005 1012 1010
1005 1012 1011
1006 1013 1010
1007
My oracle using
version is 8.0.0.5.
Now , I'm programming proc .
When I precompile them and fail. But I cant see what
happened .and where the errors are.
So I look carefully for
errors in large file.
Is there some
way to show where the error is .and what the error is .
Can you give me
They have been removed due to my rman framework scripts taking the disk
space.
Sorry.
Joe
I have found Joe Testa's site has a good set of RMAN scripts (I think
they came from Jack van Zanen off this list), quite simple but they
give the syntax for most of the commands you will want
The link
SET ORACLE-L NOMAIL
SET RMOUG-L NOMAIL
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Schafer, Connie J
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
HELP
bio oracle-l
begin 666 bio.txt
[EMAIL PROTECTED]%M:6QT;VX-D]R86-L92!$0D$-E%60R!);F,N#0H-D)OFX@
M,3$M,CM,3DU. T*2EG:!38VAO;VPZ(%-U;[EMAIL PROTECTED],L($%S=]N
M(%!!#0I#;VQL96=E.B!-87AW96QL($ENW1I='[EMAIL PROTECTED]FES=]W;B!0
M02P@,3DW. T*#0I)(%M(AA'!I;'D@;6%RFEE9!W:71H(#,@8VAI;1R
set oracle-l nomail
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ferenc Mantfeld
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
SET ORACLE-L DIGEST
signature
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Piet de Visser
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
Hi,
I was wondering how DBAs are coping with these new large disks that are
availableyou can purchase 36gb, 72gb, etc. You can fit a whole database
on one of these. But with all the performance and redundancy
considerations, you wouldn'tso what do you do with the free space? Or
how do you
set oracle-l digest
hi,
can i use a database link inside a procedure to refresh data from a AS/400
system into oracle ??
this is the sample of the code that i am using ... and it hangs endlesly...
CREATE OR REPLACE PROCEDURE PRC_TABLE_REFRESH AS
BEGIN
execute immediate 'alter session set global_names=false';
Raj,
Another consideration is a potential for a buffer busy waits. the larger the
block size is, the more the number of rows in an average block. Thsi
increases the possibility of a buffer busy wait.
HTH.
Arup
An 8.0.6 ops database being migrated to 9i RAC database on Solaris 8. The
8.0
Hi Listers,
I'm new in DBA's job. I want to ask what is 'statspack' ? does it a third
party program from oracle or a script. Where I can find the information
about 'statspack' ? or if it is a script would you please to share with me ?
Thank you in advance for your help. Every comments and clues
List,
I have to move data on a regular basis between two instances of 8.1.7 on
two different UNIX servers. The schema is exactly the same. There are 543
tables to be refreshed. It is only the new data on one of the servers
to move to the other. What is the best and easiest way to do this?
.
--
From: Stephane Faroult[EMAIL PROTECTED]
Date: Wed, 15 Jan 2003 09:06:26 UT
Subject: RE: Re: Run obsolete Oracle 7 scripts against Oracle 8i databas=
e?
v$instance changed a lot. Otherwise Jared is right about #, which was mos=
tly appended to (number) columns
Hi
Anyone has used Oracle under Solaris/Sun C++ compiler . If yes please mail me how and on whichversion.
Sunil AroraSunil AroraVichara TechnologiesDo you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now
hi,
Wish u a very New Year
Sudhakar
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: sudhakar Reddy
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
SETORACLE-L DIGEST EDOUARD DORMIDONTOV
SET ORACLE-L NOMAIL
Regards,
Deepa
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
SET ORACLE-L NOMAIL
which
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
HELP
Gurus,
I was just given a project to maintain a Computerized Maintenance
Management System. When I asked the companies support staff how to roll
back patches in the backend Oracle Database (Ver. 8174), they said that
there was no way to do this. I'm guessing I could use logminer just incase
List,
Is there anyway to know absolutely that a table is not in an export file?
My import bought in 6 tables, but not the seventh ( I don't think it is in
the export). The import bought in the other 544 tables! I have queried
under the schema name, after logging in as that user:
select
set no-mail
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
Hi,
How can I complie PRO*C code.Please
Thnks
Hello fokls. First, I do not and have never worked for Oracle. I thought I'd show you
some funny and interesting comments from the Oracle source tree that I've been made
privy to. Here is today's installment.
/* retch, gag, choke. If this bit is off, oracle doesn't break/reset
Hi,
I've installed Application Server Infrastructure 9i Release 2, but i
skipped the configuration assistants. The Enterprise Manager Console
doesn't discover the Oracle HTTP Server even if was started with the
dcmctl utility. Are there configuration tools that configure the HTTP
server and
Hey
Guys,
I
used FGAC for a small application a year ago without problems/issues. I have
reread the docs and now I would like to know the experiences of those using
FGAC for larger systems.
I
am now working on an OLTP system that will have tables in the 4+ million range with 100+
Hi
I have unpartitioned table with aroung 2 million rows. When I was creating
an index on the table, it failed as it was not able to extend the temp
segment. I added a temp segment and recreated the index.
But now i see the index is created on some columns which cannot be seen in
the DESCRIBE
What is the syntax to delete multiple objects,
or more specifically multiple tables from a user in 1 go.
I need to delete 50+ tables/objects without
deleting them 1 by 1.
Thanks
Clint
Hello,
Could you explain me how to deal with folowing error:
select * from sysaudit@tg.big
*
ERROR at line 1:
ORA-28509: unable to establish a connection to non-Oracle system
ORA-02063: preceding line from TG.BIG
(HP-UX 11, Oracle 8.1.6, tg4ifmx 8.1.6, Informix 9.2)
Hello
all,
I have a client who will
be doing the data capture and give me the data in a flat
file.
what i need to do in
oracle is load from that flat file to my database.
any scripts
available ?? please send me across. ASAP
Thanks and regards,Santosh
set nomail
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tom Pal
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
Hello
all,
I have
a query -
i have 2 tables
- client and project
fields in project
table - clientid/projectid
fields in client
table - clientid/name
i want to get the
maximum orders one client has got. i mean a project having the
greatest clients
how to write it in
single query ??
HELP
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
SET ORACLE-L NOMAIL
_
This email is confidential and intended solely for the use of the
individual to whom it is addressed. Any views or opinions presented are
solely those of the author and do not necessarily represent those of
List,
Does anyone know of some good resources about gathering statistics on Hash
Clusters. I am particularly interested in finding out how full our buckets
are and any chained links we have currently.
Thanks before hand for you help.
Tim Boles
DBA
Lockheed Martin Information Systems
[EMAIL
NOMAIL ORACLE-L
__
Do you Yahoo!?
New DSL Internet Access from SBC Yahoo!
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
Fat City Network Services--
Hi friends
I am using following command to call report from
report
srw.run_report ('report=d:\test.rdf destype=file desname=try.out
desformat=dflt batch=yes');
I have tested this using After Report /Before Report/Action Trigger.
But this is not calling the report.
Any solution will be
Please don't sent any more mail to this ID
Please take it as a request
Please ignore my name
Mail ID : [EMAIL PROTECTED]
Thanks
System Admin
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: RO-Hosur
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
Hi,
I would like to know which datatype is best to use for storing text data
of around 50 lines.The data is basically a variable length user
feedback.I am in confusion whether to go for VARCHAR2 or LONG type.
Also in CLOB and NCLOB, can somebody clarify me about CLOBS store
single-byte
Oracle 8.0.5
AIX 4.3.3
I Have following statement, which takes forever and does lots of physical
reads
**
insert into test_table
SELECT v1.engagement, v1.YEAR, v1.period, MAX (v2.net_fee_earned_ptd)
,
I just found a Korn shell script on-line to Delete RMAN backupsets older
than a specified number of days. It has syntax in it that RMAN doesn't
like, and I can't find a reference to what the script is trying to do
anywhere.
OS: HPUX 11i
Production DB: Oracle 8.1.7.4
Recovery Catalog DB:
Hello All,
We are trying to install Oracle9i on RED HAT linux 7.2
and getting following message:
THE JAVA RUNTIME ENVIRONMENT WAS NOT FOUND AT
TEMP/BIN/JAVA
THE ORACLE UNIVERSAL INSTALLER CAN NOT BE RUN.
I have looked through metalink but could not find
anything satisfying. I would like to
SET ORACLE-L NOMAIL
__
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: kommareddy sreenivasa
INET: [EMAIL PROTECTED]
Fat City Network
Oracle releasing clustered file system code
The move is designed to allow better management of databases on Linux server
clusters.
http://computerworld.com/newsletter/0%2C4902%2C73404%2C0.html?nlid=AM
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL
Hello,
I have a question regarding method of index access(full vs. range) that
oracle uses when I use different join methods (Hash vs. Nested loop).
Here are the some details about the environment.
Server : Oracle Server EE ver 8.1.7.2
OS :
Hi,
there is a Geman server offering a list archive
http://www.doag.org/orafaq/afl-oral.htm
they have a lot more links on
http://www.doag.org/orafaq/faq2.htm
Regards,
Antje Sackwitz
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sackwitz, Antje
INET: [EMAIL
Guys , my insert statement is below . explain shows 828 for redo
size . does it mean the no of blocks ? what should be the ideal
value for the same ? what does the value for redo size = 828
indicate ?
kindly explain me.
insert into MSG_History
Hi Guys,
I need to put one hour back for my OS(aix) So How will my database(7.3)
handle this?? What steps I have to take?? Any light regarding that??
Thanks in advance
peter.
_
Chat with friends online, try MSN Messenger:
i have oracle 8i on windows 2000 server. i have
installed developer 6 . Now i can not connect
database. Now I
get the message on startup:
Could not start ORACLEORAHOME81AGENT service on local
computer
error 3221356553.
When i want to start svrmgrl i got sp1 lang.msb
not found.
what can i do to
SET ORACLE-L NOMAIL
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: RAHUL GAJANAN MEHENDALE
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
CONFIRM L-ORACLE
Thnx OK Bye
Instant gratification
takes too long
-- Carrie Fisher
Chris Royce
[EMAIL PROTECTED]
[EMAIL PROTECTED]
winmail.dat
CONFIRM ORACLE-L
Thnx OK Bye
Instant gratification
takes too long
-- Carrie Fisher
Chris Royce
[EMAIL PROTECTED]
[EMAIL PROTECTED]
winmail.dat
SET ORACLE-L REPRO
END
Thnx OK Bye
Instant gratification
takes too long
-- Carrie Fisher
Chris Royce
[EMAIL PROTECTED]
[EMAIL PROTECTED]
winmail.dat
Hi,
as you were discussing that the message was sent to recent posters I guess
you are right.
I am twice assigned to the list, once at home and once with my office mail
account.
As I did recent postings to the list from my office account I only received
the Ellison Comment mail at my office mail
no application server involved.
thx
Sameer
--
We can definitely find the user ,
but considering my scenario 'all the people are logged
in with the same oracle user' ,
I want to know:From what machine the SQL statement was
fired.
thx
Sam
name--- Reardon, Bruce
Hi,
I am facing a very strange problem.
Oracle 7.3.4.4.1 and HP 10.2
I do an analyze of a huge table (more than 46 million records) .
The query which hits this table and 2 other table has an RULE hint .
On the day analyze fails on the big table, performance is very very slow .
But with
I have Oracle 8i with 4 instances and Oracle 9i with 1 instance.
How can I just remove all of Oracle 9i without touching Oracle 8i?
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
HELP
How much memory is allocated to
each login to Oracle?
Is it not 20-30mb? I have heard
people mention of 300mb? Surely this would bring most servers down if it was
true.
Clint
Currency.gif
Description: GIF image
Hi all!
I need a solution about calling sql*loader from pl/sql. I have a version
now with external dlls, but actually I don't know the platform so it not
seems a good choice. I would like something native oracle solution with
oracle's packages or something like that.
--
Please see the
Qs Why is elapsed Time so HIGH in the following SELECT ?
NOTE -
1) TBA_GENERAL_ACCT_MAST_TBL is a SYNONYM for GENERAL_ACCT_MAST_TABLE Table
2) The Respective Tablespace Contains ONLY ONE (i.e. This) Object
(GENERAL_ACCT_MAST_TABLE)
3) There is a UNIQUE Index on the field of the Where
hi there,
I want tips regarding 1z0-023 architecture exam..
please help,
Thanks
Rohit
Hi
A developer is getting a sporadic errors when trying
to access ORacle
database via a Cold Fusion screen. The messages on the
screen are
Oracle Error Code = 0 Timeout while obtaining an
Oracle statement lock. I turned tracing on in his
session and found this in the trace file:
update seg$
Hi all,
I've got a query that returned more rows than needed.
Here is the query:
SELECT distinct
m.journal_id||m.yr_of_issue||m.ms_sequence_no||m.check_char
MSNO,
M.RECEIVED_DATE RECEIVED DATE,
M.EDITOR_NO EDITOR NUMBER,
S.STATHIST_CODE STATUS CODE,
ST.STATUS_DESC
SET ORACLE_L DIGEST
SET ORACLE-L MAIL
*
Disclaimer
This message (including any attachments) contains
confidential information intended for a specific
individual and purpose, and is protected by law.
If you are not the intended recipient, you should
delete
I'm a student dba'r running 9i on windows xp. I have created a second database (database name=bill, instance name = bill). After I first created it, I tried to mount it after shutting down the installation seed database (database name = orcl, instance name = orcl). I kept getting the message
TED]
[mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED]Sent:
Wednesday, February 20, 2002 7:54 AMTo: Multiple recipients of list
ORACLE-LSubject: (no subject)I'm a
student dba'r running 9i on windows xp. I have created a second database
(database name=bill, instance name = bill). After I
One more
thing about the script I sent -- that was for 8i,
not 9i, so check it out in that respect, as
well.
Cheers,
JoJo
INDEX ORACLE-L
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kempf, Reed
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
hi,
Anybodygot some oracle
question dumps or resources for
oracle certified
internet database administrator exam ?? (exam #1Z0
-411).
Thanks in advance
:)
rgds
sunil
Nah, Zen in the Art of Archery was the real deal - it predates ZATAOMM by
quite a few years...
Mohan, Ross [EMAIL PROTECTED] wrote:
you oughta apologize to Robert Pirsig, the guy who started the whole thing.
-Original Message-
Sent: Tuesday, January 15, 2002 12:35 PM
To: Multiple
Good morning everyone,
Can anyone give me the command to analyze a partitioned tabled? To analyze
this table unpartitioned I use: analyze table schema.table_name compute
statistics;
I am partitioning it into 6 partitions and want to compute statistics on
each partition.
Thanks in advance,
SET ORACLE-L DIGEST
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: MILLER, DAVID L (CONTRACTOR)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
SET ORACLE_L NOMAIL
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Blum, Marc
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
Hello Gurus,
I am working on a little project using the package utl_http, so far I have
had limited success using this package.
The below http call fails for some reason, it is supposed to download a
page of size ~10K, i.e. 5 pieces of data, but instead it fails, I am not
sure why...
Any
LISTS
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Koniszewski, Mike
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
1 - 100 of 197 matches
Mail list logo