Hold on Lisa!
Java is not complex. It's a very simple language
actually. It took me a week to learn it, though I'm
not using it now: I much prefer Perl.
Getting a handle on all of the libraries and API's is
another story, but Java as a language is pretty simple.
Jared
On Tuesday 30 April
Hi All,
We are looking for possible solutions to share files between Windows
Unix.
And also store millions of little files that are now a backup nightmare.
Does anybody have any experience with IFS (performance, possibilities,
pitfalls )
TIA
Jack
What is the OS ?
-Original Message-
Sent: 30 April 2002 22:38
To: Multiple recipients of list ORACLE-L
I have been reading/searching the DAMN documentation like I always do
before posting a question. It is frustrating enough to get this to
work correctly. I do not need this type of
Hi,
May be those are shared component with your old 8i, btw what are those component
regards
Sinardy
-Original Message-
Sent: 30 April 2002 22:28
To: Multiple recipients of list ORACLE-L
Tom,
I started with using the installer. It appears it installed Oracle
software. Of course
Strange,
But I can't get to see the offer now either.
Yesterday you could get all three books
Practical Oracle 8i ...
Internal services for waits, latches ..
Scaling Oracle 8i ...
For the knock-down price of $78.91 instead
of $109.89 (and I've got the html to prove it !)
Today
Well, if rumors are true, Howard Rogers ordered about 60 tons of James'
book in order to get his barbeque going. That would explain it. They're
sold out. Don't expect this special bargain again until they've
re-printed James' book (maybe with a new title like Failing Oracle9i
or such).
Hi!
On my win2k server I configured two databases one for data (MYData) and the
other for EM Repository OEMREP. The tools do not seem to be able to connect
to the database having data. The error reported is that TNS couldn't
identify SID.
The v$database shows only the OEMREP database (Could be
You THINK that you are kidding.
I submit to you that in a few years there will be a great demand for Cobol
programmers as the current old crop goes into retirement
and all the newbe's are learning Java and perl.
Start writing those books. They will be needed by the time that you finish
them.
Dave
I checked this out and it depends on the oracle version.
Editing the listener.log of 8.1.6.3.4 on NT failed as: Another process is
using the file.
The same for 9.0.1.3 on NT. Editing not problem. Marked the whole text
except for
the last day and deleted it and then I saved the file.
Size
Why? For consistnecy. I am in charge of making ALL changes to the data model, then
rolling out those changes to the db. Our developers RELY on me and my tools for a
database that reflects the model that we developed (Without Error).
Therefore, everything we do here STARTS with the model
Hello list
This time I need your help on how to implement a weird idea.
We have a third party application that fire wasteful SQL's to the database.
(Remember the discussion on using x$dual Vs dual some days ago?)
I am wondering: Is there a way to change the SQL that the user send?
In ADABAS on
How !?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arslan Bahar
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
I dont mind the PK thing, I prefer it that way, but it also inconsistently places
migrated foreign keys on the bottom (this is just mdoeling, no reverse engineering).
This is just a slight pain for us as we have a bunch of auditing fields that I like to
be last for readability. Sometimes I
Samba, best is its free.
[EMAIL PROTECTED] 05/02/02 04:48AM
Hi All,
We are looking for possible solutions to share files between Windows
Unix.
And also store millions of little files that are now a backup nightmare.
Does anybody have any experience with IFS (performance, possibilities,
what - you changing careers - trying out for Denis Miller's show?
nice rant.
you win the award for the most number of '*' words in an essay.
take a chill-pill, babe. :)
-Original Message-
Sent: Wednesday, May 01, 2002 4:42 PM
To: Multiple recipients of list ORACLE-L
It is kind of
Hi Dmit,
When you connect to a database and look at v$database, it will only
show you
information about the current database.
On win2k you should check the following:
1. go to the services panel and make sure you have services created and
started for each database
2. from the dos prompt
Independent contractors in Albany NY who know Cobol are getting $120/hour
because all of the original employees who know Cobol are retiring. And the
legacy systems are going to be around for quite awhile.
-Original Message-
Sent: Thursday, May 02, 2002 7:58 AM
To: Multiple recipients
Hello list
This time I need your help on how to implement a weird idea.
We have a third party application that fire wasteful SQL's to the database.
(Remember the discussion on using x$dual Vs dual some days ago?)
I am wondering: Is there a way to change the SQL that the user send?
In ADABAS on
Perhaps:
Export, truncate table, alter table, import
or
Create temp_table as select * from orig_table,
truncate table orig_table,
alter tableorig_table,
insert from temp_table,
drop temp_table
Imran Ashraf [EMAIL PROTECTED]@fatcity.com on 02-05-2002 14:18:28
Please respond to [EMAIL
See otn.oracle.com for Oracle Migration Workbench.
-Joe
--- Arslan Bahar [EMAIL PROTECTED] wrote:
How !?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arslan Bahar
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
Hi,
i have a column set to number(3). However this needs
to be changed to number (3,2). But i cannot do a
straight alter table as there is data in the column.
how can i get round this?
cheers
__
Do You Yahoo!?
Yahoo! Health - your guide to
v$database will always show one and only one database - the database to
which the instance you are running the query against is attached. As for
how to find out on Windows, I'll leave that to someone who knows Windows
better than I.
Don Granaman
[OraSaurus]
- Original Message -
To:
Imran,
what I do is the following:
create table temp_table as select primary_key_column, number_column from
table_to_be_changed;
update table_to_be_changed
set number_column=null;
alter table_to_be_changed modify(number_column(3,2));
declare
cursor c1 is
select primary_key_column,
Outlines is one way, but there is another sneaky way, but that involves a
lot of programming depending on what you want to change.
And it also depends on where the client runs and how it is linked
Anjo.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
I did something way back wehn using PIPES to catch a runaway third party encapsulated
pl sql code.
I dont remember the specifics but you can look at the docs for it.
Hannah
-Original Message-
From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Yechiel Adar
[EMAIL PROTECTED]
May be it's time to switch back to Cobol!
I've done it for four years (Cobol F77 with Codasyl).
Regards,
Waleed
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 5/2/02 8:13 AM
Independent contractors in Albany NY who know Cobol are getting
$120/hour
because all
Moving the columns should not be a problem for anyone, heck you should
be able to alphabetize them and everything be okay. If you take the
output and use it to create tables that should not cause a problem
except for the developer that codes for columns to appear in a specific
order.
Ron
ROR
Oracle 9i on XP Prof.
DB is on a single PC.
When I try to do a DB connection I get this error.
Yesterday I created a second DB on my PC and was able to connect successfully to
either of them. This morning I rebooted my PC and now I cannot
connect.
Any idea what the problem is?
TIA,
Ken
I finally got the website updated. For those of you who lost, never
saw, would like to review, all of the past editions of the 9i new features
series is at
http://www.oracle-dba.com
click on the 9i link.
joe
Hi,
One way is to do the following:
1. Export the table for backup purposes
2. Create a temp table containing the primary key and column to be altered.
3. update original_table set number_column=null;
4. alter original_table table_name MODIFY (column(3,2));
5. Update column from temp table.
The Virtual Private Database (VPD) facility (a.k.a. fine-grain or
row-level security) can be used to alter SQL on the server, regardless of
origin. I implemented an access control list (ACL) feature for a system two
years ago, complete with recursion inside PL/SQL for navigating the
(implied)
I can give you a hand in that :-)
Or If you want to write it in spanish.
Ramon
-Original Message-
Thomas F
Sent: Thursday, 02 May, 2002 8:13 AM
To: Multiple recipients of list ORACLE-L
Independent contractors in Albany NY who know Cobol are getting $120/hour
because all of the
I mentioned that the 32 bit solaris gz file for 8.1.7
that I downloaded from otn provided one disk image on the order
of 900MB. What technology do I need to move to in order
to burn this onto plastic? Are we talking dvd burner here?
I asked oracle what the intent was with this, the answer is
Did anyone else receive this message from a reply to the list?
Ron
ROR mª¿ªm
[EMAIL PROTECTED] 05/02/02 10:01AM
Sky City's e-mail system has stopped the following message because:
* It believes the e-mail message and/or an attachment contains a known
virus.
Message:
Start the database and listener services.
Scott Shafer
San Antonio, TX
210-581-6217
-Original Message-
From: KENNETH JANUSZ [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, May 02, 2002 9:43 AM
To: Multiple recipients of list ORACLE-L
Subject: Can't Connect to DB
Oracle 9i on XP
Hi Ken,
Is your listener started??
That appears to be the case based on this message. Go to your services and
see
if the Oracleorahomenamelistener service is started. If not then
start this service
and try to connect then. If you are getting an error when attempting to
start the
service you
Hi All,
We are in the process of developing a discovery plan. Does anyone have any
links,example disaster recovery plans,etc that I can research
for ideas.
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network
It took you a week to learn it? Then you obviously do not know it.
Syntax is one thing design is another. I would love to know what you
learned in that week.
On Thu, 2 May 2002, Jared Still wrote:
Hold on Lisa!
Java is not complex. It's a very simple language
actually. It took me a
Samba on Linux has been a life saver.
Users can map a network drive, that's nfs mounted on UNIX that's accessible
from the web.
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
I think that given Jared's strong Perl background, his picking up the syntax
was easy enough for him. Heck, I downloaded some Java programs from the web
and made changes to them while playing around, and my changes worked just
fine (I change colors of moving objects - whoopee, I'm a Java
Anjo,
Can you tell us more on the sneaky way?
Babu
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 02, 2002 8:43 AM
Outlines is one way, but there is another sneaky way, but that involves a
lot of programming depending on what you
I'd believe it.
I have a classic in my seminar where
VPD/FGAC/RLS turned a simple single
table query into a 16-table join.
There is a vague directive from Oracle
nowadays that you should only be using
VPD to generate predicates involving
sys_context() calls, rather than attaching
subqueries.
As I remember (since I'm no longer using ERWin since CA's takeover) there
is a Physical Order box somewhere than needs to be clicked. If you do
this, ERWin will use the actual physical order of the table, otherwise it
will put them in another order (I think that it's primary key, foreign
keys,
Hello Joe
Just took a peek.
Looks illuminating.
Keep up the good work.
Yechiel Adar
Mehish
- Original Message -
From:
JOE
TESTA
To: Multiple recipients of list ORACLE-L
Sent: Thursday, May 02, 2002 3:48
PM
Subject: 9i new features update
I finally got the
Thanks for the idea Tim but I am thinking about adding hints
to the sql or changing the FROM table.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 02, 2002 4:48 PM
The Virtual Private Database (VPD) facility
I am in the process of implementing partitioning on some existing tables. I
have been asked by management to evaluate the performance impacts of the
changes. I am aware of many of the performance advantages of partitioning:
partition pruning, partition-wise joins and parallel data loads. What I
Hello Anjo
If you know of a way to change the SQL at the client side I would LOVE to
know it.
We where thinking about changing the connections string on the fly (not this
fly)
And this can help a lot.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L
Greetings fellow-DBAs,
We have a web application which exists on a Windows/NT 4 box running Oracle
Standard Server 8.1.6. A new application to be added to that platform needs
Oracle 8.1.7 (They've even specified needing Patch Set 8.1.7.2.1 and ODBC
driver 8.01.74.00).
I have just ordered the
I did this exact upgrade a very short time ago, using Option1. It
worked just fine. I would add step (6a) install patches up to 8.1.7.3.,
after the database has moved to the new version.
I would stay away from Option2. You have no fallback.
-Original Message-
Sent: Thursday, May
Hello Ray
I think that the intent is for you to burn the gz file and expand it on the
target system.
I installed today upgrade 9.0.1.3 for NT that came in the same way.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday,
Option 4:
Install 8.1.7
shutdown the database
change ORACLE_HOME etc etc to point to the 8.1.7 ORACLE_HOME
startup the database
You shouldn't have to rebuild the database when moving to a minor release
Rachel
|+---
|| |
||
Hello Ron
shameless plug
I was just looking at Joe new oracle 9i features at
http://www.oracle-dba.com
end shameless plug
I saw that log miner gives you something like:
update SCOTT.TEST_LOG set C2 = '10'
What happens if you extract this info and erd tool moved a column?
Inquiring minds wants
Thanks Joe.
Jared
JOE TESTA [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/02/2002 06:48 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:9i new features update
I finally got the website updated.
My last set of test results is a little out of date,
but here's an idea to check.
Inserting single rows:
partitioned key insert HAD ca. 50% overhead
Array Inserts sorted by partition key to get lots
of adjacent rows in the same partition
virtually no overhead
Array inserts randomised
It took you a week to learn it? Then you obviously do not know it.
Syntax is one thing design is another. I would love to know what you
learned in that week.
Getting a handle on all of the libraries and API's is
another story, but Java as a language is pretty simple.
Jared
Well Jared,
He
Way back in the days of Oracle 8.0.5 I did some performance testing of bulk
inserts/sqlldr of range partitioned tables v.s. non-partitioned tables. I
don't have the benchmarks on hand, but here's what I found. All tests were
done using the direct path inserts (sqlldr direct=true or /*+ APPEND */)
Lisa,
There is only so much you can control via a model,
since it remains a process away from the DB, and
cannot be enforced via privileges, etc. So, we are
always in the hands of Dom Phoc (and their siblings),
who can do stuff even in the production database
with SQLPLus/TOAD/... Under this
Well, there *is* a product that allows you to do this.
http://www.teleran.com/products/iguard.htm
This product t intercepts SQL and lets you do all manner of
interesting things to it.
Implementing something like this is rather expensive
( 6 figures minimum, U.S. Dollars ) and probably not
Yes. Your suggestion is correct.
After you run Reverse Engineer to get the table diagram from database, right
click the blank area. Small windows show up and select Stored Display
Settings, select Physical tab, select Physical Order in Display Level and PK
Designator. The diagram will be
You can
Lsnrctl
status
Will return a list of running databases on the server.
Bob
Sent: Thursday, May 02, 2002 10:18 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: How to know if another database is running on
the same machine?
v$database will always show one and only one
SAMBA would be much easier to implement, and certainly
adequate if you just need a file server.
http://www.samba.org
Another advantage: it's open source
Jared
Jack van Zanen [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/02/2002 01:48 AM
Please respond to ORACLE-L
To:
It ain't that tough. We're not talking about taking a programming
class without any experience, I've done a bit of it before.
Learning all the API's, etc.: that would take some time.
The language? It isn't that difficult, though I would be
hard put to write any at the moment. The job I was
Yes, I always have that box checked. I still get an mixed order columns
when I gen the DDL.
Yes, 4.0 sucks. One of the projects here actually purchased 4.0, but then
had to fall back to 3.5.2, because of the bugs. Let's all thank CA for
taking another fine product and destroying it.
Ah, didn't make the connection.
crontab -e: now that's just nuts. ;)
Jared
Steve McClure [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/02/2002 10:43 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:
Hi List,
When I try to create a new database (8.1.7) under sun solaris I got the
following error:
ORA-03113: end-of-file on communication channel
Any Idea? Any help realy appreciated.
This is the contenet of log file which created:
Connected.
ORA-03113: end-of-file on communication channel
Hi ,
i have a procedure to open the BFILE
data.
CREATE OR REPLACE procedure openmyfile as
lob_loc bfile;
filesize number;
lob_loc bfile:=bfilename('IMG','a.jpg');
begin
--select f_lob into lob_loc from lob_table where key_value=21;
dbms_lob.fileopen(lob_loc,dbms_lob.file_readonly);
On Thu, May 02, 2002 at 09:18:31AM -0800, Yechiel Adar wrote:
Hello Ray
I think that the intent is for you to burn the gz file and expand it on the
target system.
I installed today upgrade 9.0.1.3 for NT that came in the same way.
Yechiel Adar
Mehish
Other Oracle distributions I have
Java this...PERL thatCOBOL rules It's easy to write and
maintain...back to writing my book...
-Original Message-
Sent: Thursday, May 02, 2002 2:14 PM
To: Multiple recipients of list ORACLE-L
It ain't that tough. We're not talking about taking a programming
class without any
Two years ago when partitioning came out we ran some tests. We found out
that oracle had some coding problems if you were using 8.0.5.
Everything ran okay, but it was slow.
The problems was with how the determined which partition to put data into.
If you had 200 partition and data was being
Thanks Keith, I'll check it out.
Lisa Koivu
Oracle Database Baby Oven
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
-Original Message-
From: Keith Peterson [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, May 02, 2002 1:55 PM
To: Multiple recipients
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
Hope it's not the program that triggered the whole Enron thing :)
Regards,
Waleed
-Original Message-
Sent: Thursday, May 02, 2002 2:14 PM
To: Multiple recipients of list ORACLE-L
It ain't that tough. We're not talking about taking a programming
class without any experience, I've
Hello,
We are working on (2) HP 9000 64 bit HP-UX 11.0 in an OPS cluster (non mts)
on version 8.1.7.2.1 32 bit, we were encountering ora-4031 errors on one of
the instances, so we increased the amount of shared pool memory from 100mb
to 200mb on both nodes in the cluster. Since the shared pool
Ron wrote:
Did you use the changed ERD to create a table and then use old archives to
mine the data changes?
NO.
I did not started to work with log miner yet.
I just saw the article that Joe published and thought about this point.
I have enough experience to know that you can not teach old
Which version exactly?
If on version 8.1.7.0, you should upgrade to 8.1.7.2 before creating any
databases. 8.1.7.3 is available, but rife with bugs.
Jared
Hamid Alavi [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/02/2002 11:28 AM
Please respond to ORACLE-L
To: Multiple
You don't say.
-Original Message-
Sent: Thursday, May 02, 2002 2:38 PM
To: Multiple recipients of list ORACLE-L
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
You must be pretty smart then. I wonder why rates for java are not $6/hr
seeing that it only takes a week to learn.
You could probably say any language is easy to learn; it is just ifs,
elses, and loops.
On Thu, 2 May 2002 [EMAIL PROTECTED] wrote:
It ain't that tough. We're not talking about
Any messages in the alert file, like dynamic lock allocation or resource
allocation ?
In Oracle8 locks and resources for OPS are dynamically allocated from the
shared pool after the initial values of _LM* are used.
You can monitor that in v$resource_limit.
Anjo.
- Original Message -
To:
-Have another beer
Excellent advice. I think I'll do just that.
Dave
-Original Message-
Sent: Thursday, May 02, 2002 2:29 PM
To: Multiple recipients of list ORACLE-L
yeah, yeah Chris, whatever.
Have another beer and do some creative writing.
;-{)
Jared
Grabowy, Chris [EMAIL
Well Keith
Our solution to the Doom Phoc (and their siblings) is:
Do not grant they rights to do any DDL either in test nor in prod.
The dab stuff does all the DDL work.
Sure it is an added chore, but after tracking down, a few times, tables that
were dropped
inadvertently by users (their tool
I don't know why you are getting the ORA-3113
I was merely trying to offer some advice based on limited information.
ORA-3113 is a 'catch all' error; any number of things can cause that
error.
Are there other errors associated with it?
Please include the list in your replies so as not to
Yes indeed. Have often wondered why Perl is'nt
considered cross-platform. After all, is'nt it true
to say that it probably runs on way more platforms
than Java, can be programmed either straight or OOP,
is fast and relatively easy to learn. Did I mention
it's free.
Gotta love those open
I think there is a book called Java for Dummies.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Boivin, Patrice J
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
Please, someone. Savor a thick and tasty Guinness for me...
I even had someone call my house wanting to do a survey on beer. I laughed
at him and hung up.
Lisa Koivu
Oracle Database BABY OVEN
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
-Original
Big hardware. ;)
But seriously, that's not a question to be answered easily.
A team that I was a member of spent 9 months answering that question.
There's a lot more to it than just determining which piece of HW the
main database resides on.
But anyway, our answer for the main piece of HW
Shouldn't there be another goal like query the data? How about query
the data while refresh is running?
If you're on UNIX, I'm guessing that dd and grep should do just about
everything for you...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
Ahhyes...COBOL for Dummiesthat sounds like a good name for a
book
-Original Message-
Sent: Thursday, May 02, 2002 3:54 PM
To: Multiple recipients of list ORACLE-L
I think there is a book called Java for Dummies.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified
No messages in the alert log about dynamic lock allocation, the node that is
having the issue has a small load on it right now and the memory is still
being used up.
Thanks
-Original Message-
Sent: Thursday, May 02, 2002 3:29 PM
To: Multiple recipients of list ORACLE-L
Any messages in
that was me! rude of you to hang-up on me! I was just getting to the good
questions!
Please, someone. Savor a thick and tasty Guinness for me...
I even had someone call my house wanting to do a survey on beer. I laughed
at him and hung up.
Lisa Koivu
Oracle Database BABY OVEN
Fairfield
Yes, what you describe does work. However, when the person you don't trust
is another DBA (Can we think of another name considering this guy is a DBA?
Doom Big Ash-Hole?), it's another story.
Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft.
No need for query as we know it. Strictly bulk data collection/delivery.
There may be a need for some cleansing. We've had a limited exposure to
Informatica and believe it would meet our light needs in that respect.
Gary Weber
-Original Message-
Sent: Thursday, May 02, 2002 3:59 PM
To:
Where can I download the Patch2 for Oracle 8.1.7.0 SunOS 5.7
I couldn't find anything like Patch2 or Patch3
Thanks for HELP
-Original Message-
Sent: Thursday, May 02, 2002 11:22 AM
To: [EMAIL PROTECTED]
Cc: Hamid Alavi
Which version exactly?
If on version 8.1.7.0, you should upgrade
You...must...resist.
Only...afew.more...days.
:o)
-Original Message-
Sent: Thursday, May 02, 2002 3:04 PM
To: Multiple recipients of list ORACLE-L
Please, someone. Savor a thick and tasty Guinness for me...
I even had someone call my house wanting to do a
Hello:
Hope the subject make sense. I'm new to LDAP, and
don't know how it works.
I need to use SQL Loader to load a text file into
Oracle817 Database from a unix box. The file/data
comes from LDAP server. My question is: how do I get
the file/object from LDAP site from my unix script?
Does
or processing time requirements??
I suggest Perl. ;-)
-Joe
--- Tim Gorman [EMAIL PROTECTED] wrote:
Shouldn't there be another goal like query the data? How about
query
the data while refresh is running?
If you're on UNIX, I'm guessing that dd and grep should do just
about
everything
Hello:
Hope the subject make sense. I'm new to LDAP, and
don't know how it works.
I need to use SQL Loader to load a text file into
Oracle817 Database from a unix box. The file/data
comes from LDAP server. My question is: how do I get
the file/object from LDAP site from my unix script?
Does
ORA-03113 (and ORA-03114) are error messages issued by the client process,
not generated on the server (like most ORA- messages). Both essentially
are complaints by the client process (i.e. SQL*Plus) that there is no longer
a connection to the database server process. The usual way this occurs
Yechiel,
In the instance that you refer to it could present a problem if you
use the changed table description to build a different instance and
then used the mined info to update the table in the new instance. This
would be a case where the source and target databases are not the same
and then
I hope you can read UGLY Perl code.
HTH YMMV!
#!/usr/local/bin/perl
# File: chg-oracle-passwd.cgi
use Net::LDAP;
use Carp;
use DBI;
$ENV{ORACLE_HOME} = /db02/app/oracle/product/8.1.6;
print Content-type: text/html\n\n;
print HTML\n\nBODY\n\n;
#print METHOD = $ENV{'REQUEST_METHOD'}\n;
if
What you have is a database that only supports full table scans and only
allows cold full database backups and cold full database restores.
Hopefully, you're never just seeking anything less than a full file, there
are no referential-integrity issues between the files, and the availability
1 - 100 of 132 matches
Mail list logo
