 | | | Oracle List | | Can 't you use IPC protocol for your db link?
Igor Neyman OCP DBA
ineyman@(protected)
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)Thanks for the correction Tanel.
Graeme
oracle-l-bounce@(protected) wrote on 06/11/2004 08 25 33 AM
> > The hash function in this case is based on the session id of the
> > connecting userYes on the high end there 's Oracle Transformation Services. On the
lower end you use SQL*Loader or external tables SQL PL/SQL
transparent gateways heterogeneous services etc..... It 's doable(sorry about the format of the previous message -- this one should work better)
I know people will come up with reasons why NOT to run Oracle on OpenVMS. I just miss it... (
http //www.comCharlotte
The biggest benefit that I see is the reduction of one step in a data load
process.
Normally we would load data (using sqlldr) into a staging table and then
use PL/SQL to process test
--
http //www.freelists.org/webpage/oracle-l
Hi
Saw this product reviewed on orafaq website and took a look at it. It is
inexpensive and has some great Oracle tools schema or database copy create
test sample data DDL generation imp/exp I am planning the migration of my data warehouse to new blade servers with
10g on Linux. I have a san with forty 72 gig drives. I am confused about
how to setup the fault tolerance with the ASM. And the virtual magic 8 ball winner goes to Conncer who got me out from
behind the eight ball!
Thanks to all. Another good suggestion that was just sent to me was a
materialized view but it woulDear List
I am looking for a good way to measure the "really " reserved memory (the
reserved address space Working Set + pure VirtuallyAllocated memory) for
a running 9.2 database on Win32 (somApologies - readable log attached.
-----Original Message-----
From Barr Stephen
Sent 03 November 2004 10 48
To Oracle L (E-mail)
Subject skip_unusable_indexes
We 're attempting to load
Hi
Please Unsubscribe my ID as I am unable to access this Mail id .
kindly advice how to unsubscribe ......
Regards
Srinivas
--
http //www.freelists.org/webpage/oracle-l
Hi Jonathan
This is really great news. Thanks for the information.
On Tue 2 Nov 2004 20 38 50 -0500 Jonathan Gennick
<jonathan@(protected) > wrote
> Tuesday November 2 2004 8 24 12 PM DI wonder if this wrapper function idea may hurt or help in some
cases w/r/t function based indexes?
The wrapper is an interesting idea and good for some tests. -)
Regards
Mike
On WDear List
I have a table which insert data by 300 users then they browse the
data then delete it(all thru a store procedure) in my store procedure
I pass a sequence number then insert this sequHi
Last week while creating a new datafile for an expanding tablespace I
received the ORA-00059 (max number of db_file exceeded). The DB is used
in a 24/24 env. So I can 't easily plan a bounidid sometihng like this to prevent access.
can be refined as needed
this can be called forme a trigger.
CREATE OR REPLACE procedure set_t_batch
AUTHID CURRENT_USER
IS
v_sid v$session.Ethan
We 're currently building something with Oracle workspaces. Our application
is something like the one a poster mentioned recently scientists uploading
sreadsheets into the database only thaPerhaps you can check the program column of V$SESSION in a logon
trigger?
Rich
-----Original Message-----
Sent Tuesday November 02 2004 7 24 AM
To oracle-l@(protected) ORACLE-L@(protected)
Looks like one of those great DB designs where all constraints are enforced
on the application side ...
Different random thoughts
* What does V$SESSION show in program and (I 'm a dreamerSince I can not disable a role through a logon database trigger I am
seeking help in how to prevent a user from updating tables outside of
the third-party application. The user is granted a role wHi DBAs
My customer is using Oracle Text 9.2
We having this little issue
If he tries to search something for example "DW-40 " he wants to have
the following results
- "DW-40 "
- "DW 40 "
-Paul
This is because when u try to open the Db thru OEM it is looking at the
init file in different location. You have to specify the correct path
where the pfile is located.
/- Vin
-----OriginYou don 't in 9i
The FAST_START_IO_TARGET initialization parameter is used to specify the
maximum number of dirty blocks in the buffer cache. 20
Its use has been deprecated in favour of the FASTHi
I noticed that
stdby.AWC.COM
(DESCRIPTION
(ADDRESS_LIST
(ADDRESS (PROTOCOL TCP)(HOST aero-v11knrvzlg)(PORT 5112))
)
(CONNECT_DATA (SID prod)
)
I would highly recommend utilizing the additional memory and CPUs...then
post a more specific question regarding the reasons behind the upgrade i.e.
what the upgrade was supposed to fix/improve withWE have upgraded the Oracle database server by adding 4 more processors and 3 gb of ram. What oracle configigurations needs to be changed to take advantage of this upgrade.
Thanks
----------I am losing stats post- major partition DDL operations on 817400. It 's bug
2306067.
I did the research asked for a one-off from ML and the tech said 'we need
proof '.
I did the work on my testHi
Ref Oracle with .Net by Apress
FYI In stock at bookpool
http //www.bookpool.com/.x/h4iqdza9v1/sm/1590594258
Recent discussion
http //asktom.oracle.com/pls/ask/f?p 4950 61 2763438257Hi All
can someone give a clarificaiton
On Solaris 5.9 do we have teh 9.2.0.6 software directly availabel for installation.
or should we install base version 9201 and go with patches ?
what |
|
|
