Right
BUT: make sure you do not use any option that does not exist in the standard
edition
but existed in the enterprise edition.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, May 07, 2002 12:18 PM
Dennis
Sorry to disappoint you all.
I gave him the password so he can connect as the owner and then he can
do truncate.
I scanned the list later and found the discussion on the subject
and I am going to replace that with a procedure that he will be granted
execute.
Yechiel Adar
Mehish
- Original
Sorry
I meant to say partitioning is not available in SE - not replication.
Yechiel Adar
Mehish
- Original Message -
To: [EMAIL PROTECTED]
Sent: Thursday, May 09, 2002 3:21 PM
Yechiel - Do you have more information (9i and replication)? Previously
there was a document on Oracle's
drive).
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, May 10, 2002 12:47 AM
We have an 8.1.7 SE database on a server which is currently NT4 SP6. The
System Admin group wish to upgrade the server to W2K and propose doing so
this quarter.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, May 10, 2002 5:58 PM
Are these addons to OEM worth buying?
Thanks
Peter Schauss
Northrop Grumman Corporation
[EMAIL PROTECTED]
--
Please see
Hello Andrey
KISS - Why write code to do what oracle does for you?
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, May 13, 2002 6:23 PM
Dear list !
I need a very simple thing : each time a certain field is null
Hello Andrey
KISS - Why write code to do what oracle does for you?
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, May 13, 2002 6:23 PM
Dear list !
I need a very simple thing : each time a certain field is null
Peter thanks.
I forgot that null insert is not converted to the default.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, May 13, 2002 11:03 PM
Hello Andrey
The correct answer depends on what you want !
if you can
Got Oracle Update from Xephon today (May
2002).
The lead article is about online redefinition by Sameer
Wadhwa
from NuGenesis Technologies.
His article agrees with you.
Yechiel AdarMehish
- Original Message -
From:
JOE
TESTA
To: Multiple recipients of list ORACLE-L
The configuration will be:
Regular servers - NAS
Database servers - SAN
I looked inside and they have connectors for fiber channel.
The nice thing about it is that I can as many mount point as I like.
No more one big raid-5 logical drive.
Yechiel Adar
Mehish
- Original Message
Title: Safe Database Environment
Hello Hussain
We are working with oracle 8.1.6 on wintel
machines.
We had the same problem and we solved it using advance
replication - synchronous.
We have scripts ready that drop the replication on each
computer if one become unavailable.
The databases
Have you tried to put a DD card for internal reader and write to this DD
with utl_file?
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, November 21, 2002 1:49 AM
Thanks but EVERYTHING is on the mainframe (including
offer help, suggestions, work around etc...
Yechiel Adar
Mehish
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yechiel Adar
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list
Ora-00205 means that oracle can not find one or more control files.
Check your init.ora parameters.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, November 24, 2002 1:23 AM
ver 8i NT4.o
all services have been set
the historical data.
Do not forget - the more time it take to import the historical data the less
you have to do since some days already passed :-).
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, November 24, 2002 7:23 PM
Dear
Title: BackupExec & Oracle
We use BackupExec for remote sites.
We installed the agent on the database server and
configure the backup jobs from the BackupExec menus and all is well. We did a
test yesterday and restored a database to a new computer and all works
fine.
When restoring to the
: Replication and failover. Will keep you all posted.
Yechiel Adar
Mehish
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yechiel Adar
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list
do google search on '+Unix +user +group'.
you get about 2M results.
I am sure one will be ok for you.
Next time please do this BEFORE mailing the ORACLE list.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, November 28
Can you explain a little about SAP cluster/pool?
They are going to put SAP in our system and anything I can learn beforehand
will be welcome.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, November 26, 2002 7:42 PM
Ah
Title: NT Memory Leak 7.3.4
I think that you need to check if users are
terminating connections.
The connections are part of the oracle.exe memory, so if
the user just close his machine at the end of day it may be possible that the
treads are accumulating and using memory.
Yechiel
Title: Pro*C for Oracle 817 on Win2000?
We only apply patches as needed and where
needed.
For example: I had a problem with export taking a long
time on one system.
I installed a patch for this problem (after testing in
test environment of course) only on that database.
My motto is: If it
On windows you can use the DBA console/OEM console (on 9i):
select the database then go to space-tablespaces.
Right click on tablespaces you get: Create.
Or - read about the create tablespace command in the manual.
(which you need to do anyway to understand what the GUI is doing).
Yechiel Adar
Hello Guang
From your note about weekly one day long import I think that you are dealing
with DW.
1) Am I correct?
2) Are there other updates to the database while the import is in progress?
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
Building replication is usually somewhat lengthy process.
I spent sometime with an Oracle expert and built a skeleton script
to build my replication via sqlplus.
However, I use the replication manager to track the progress of
the build process and to check the results.
Yechiel Adar
Mehish
Interesting. Thanks.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, November 27, 2002 5:54 PM
SQL Injection and Oracle - By Pete Finnigan
This is the first article in a two-part series that will examine SQL
I think that SQLBackTrack from Precise can restore a table from a backup.
Of course you will need to backup with it, not Rman.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, November 30, 2002 12:39 AM
Hi Listers
you can export the selected records only from your tables and import them
to the seconds DB.
HTH
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, December 02, 2002 1:43 PM
Hi,
what's the best method to move some
So do a select from a view based on sys.x$dual. That does not have cause
LIO.
I checked a few months ago.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 03, 2002 4:32 PM
and that select 'PING' from dual
Sorry, as Kirti pointed to me the product belong to BMC.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, December 04, 2002 1:53 PM
I think that SQLBackTrack from Precise can restore a table from a backup.
Of course
Hello Vladimir
We decided to separate the copy of the archive logs to
tape and the deletion of them. This copy is run several times during the
day.
So, copy all the archive logs to tape without delete and
once a day delete all archive logs older then one day. This way you have
multiple
I posted the original post.
alter database rename global_name to new_global_name;
After this you can create links between the two databases
while using global_name=true.
I learned the trick while building advance replication.
Yechiel Adar
Mehish
- Original Message -
To: Multiple
Hello Vladimir
I think that you need to take a look at the file before
and after applying "unix2dos". Since you work with CE characters, maybe the
conversion program can not handle this.
BTW - in Oracle 9.2 you can use utl_file to write Unicode
to the file. Maybe this will help you.
I think you missed the bit about after some manipulation.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 10, 2002 1:23 PM
If you are sadomasochist you can try Oracle replication :-)))
JP
On Tuesday 10
Have you tried: create or replace Java machine; ?
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, December 09, 2002 10:08 PM
Anyone seen this export error? The database is Oracle EE V8.1.6.2 on
Solaris 2.8
Title: RE: Help Urgent Where is Tablespace Manager??
What is the tablespace manager?
When I bring up DBA studio I do not see it
anywhere.
8.1.6 on NT
Yechiel AdarMehish
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Monday,
I think that if you use Bfile oracle will not copy them to the standby
database.
It will only copy the pointers in the database.
You will have to copy the files yourself.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday
.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 10, 2002 8:03 AM
Thanx Chao.
Still under confusion , whether to store 20,000,000 images of 5k
each either in
-oracle 8.1.6 on win2k ( BLOB or BFILE
Simple.
run statsdrp and statscre.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, December 09, 2002 6:14 PM
Hi
How to clean all old STATSPACK data?
Thx
-Seema
I think the logic is wrong.
You could build the fact table first and then add lookup tables and the
constraints.
You have to know your data and order it by hand.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December
Maybe you can do this:
1) imp index=n constraint=n
2) imp ignore=y rows=no
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 10, 2002 11:58 AM
Hi all,
I have dump files (1 table 1 dump file, dump filename
behavior and, believe me, you need those guys the same as me.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 10, 2002 5:49 PM
Jeremiah,
I am seeking for help. If you are not willing to help then just SHUT
There is a parameter to tell the archive process to ignore errors on
secondary locations and to proceed normally if one succeed.
as it is 23:00 here, I do not remember the exact parameter.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED
Title: RE: Oracle 9i installation - Basic Qs - HELP!
Why not use this parameter?
I can(on NT but I am sure Unix can do the same)
define drive letter X as a disk on another machine and the OS works with it as a
local disk. This way you can use the oracle feature without inventing the wheel
to be 1900MB each.
Also each tablespace has an extra datafile with 200MB size
with autoextend up to 1900MB.
Our checks check that each tablespace has datafile with 200MB size.
If not we get an alert and check the situation.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients
I do not know if this was a configuration error or
something that is built into access but some time ago a package based on access
stopped working. We found out that the access database got to 1GB size and
stopped growing so they could not insert new data into it.
Yechiel AdarMehish
not have to export/import/notify users etc.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, December 11, 2002 5:33 AM
Hi,
We have 8.1.6.0 installed on a NT server. There are 2
databases(development of size 120MB when
Use 1 2 for the parameters passed from the command line.
If you had (test.sql) a script like:
select 1 from dual;
exit;
and you write on the command line:
sqlplus Scott/tiger@db @test.sql 'kuku'
It will become:
select 'kuku' from dual;
Yechiel Adar
Mehish
- Original Message
Title: arc destination odd behavior
Hi Lisa
We do things a little different her and have no
problems.
Before backup we run a script that set the archive bit
on
for all the existing archive logs:
attrib *.* +a (they are written with the archive bit
off).
after BackupExec finished the backup
crashes but you can start again and resize
the datafiles.
2.2) Archive log - restore and regenerate to a point in time prior before
the resize.
This bug was reported also on 9.2.
The work around is to resize to 4.1, 8.1 GB datafiles.
Bug number 1668488.
Yechiel Adar
Mehish
- Original Message
HTH, But your cut paste still need some help :-)
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, December 11, 2002 2:19 PM
Thanx alo Yechiel Adart!! It worked.
Kranti
Yechiel Adar
Hello Krishna
I just tried to open a datafile using textpad and got
sharing violation.
I tried opening using notepad and it worked.
For obvious reasons (not trying to test recovery) I did
not change and save the file with notepad.
Yechiel AdarMehish
- Original Message -
From:
You may be right if you want to delete part of the accumulated stats.
He asked about removing ALL the old stats.
Drop and recreate seems to me a good and fast way.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday
In a seminar about three months ago they told us that the advance server
version does not contain anything that you can not put together yourself by
downloading and compiling.
But - this is a lot of hard work.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list
I created a test table and build an index on columns t1 and t2.
Explain plan for: select min(t1) from test where t2=4;
was resolved using the index only so I think that will be very efficient.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
Title: RE: Active sessions chewing up a huge amount of RAM
You can try concatenation.
Pseudo code:
c1 := null
c2 := null
c3 := null
open cursor
while not end-of-set
c1 := id || ' '
c2 := name || ' '
c3 := vale || ' '
end-loop
Yechiel AdarMehish
- Original Message -
From:
see:
http://www.oracle.com/ip/deploy/database/oracle9i/index.html?packagingandopt
ions.html
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, December 12, 2002 7:43 AM
Hi List ,
I have one question please,what is main
of
corruptions, which I have started using right now. Let me know if it is useful
to you.
HTH, Krishna
- Original Message -
From:
Yechiel
Adar
To: Multiple
recipients of list ORACLE-L
Sent: Wednesday, December 11, 2002
10:14 AM
Subject: Re
Private Database
Fine grained auditing
All OEM packs
Oracle OLAP
Oracle Data Mining
Oracle Spatial
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, December 12, 2002 1:13 PM
Mr .Adar
sorry ,i can not find this link
You can use
select translate(field1||chr(126)||field2||chr(126),chr(015),' ')
in the program that creates the sequential file.
this will replace every chr(015) with blank.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday
not made a test, just from searching the manual.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, December 12, 2002 1:54 PM
Thanks for that Peter and Yechiel, whilst both posts were useful I don't
think they really answered
Title: RE: Active sessions chewing up a huge amount of RAM
I looked again and of course the concatenation should
be:
c1 := c1 || id || ' '
c2 := c2 || name || ' '
c3 := c3 || value || ' '
Yechiel AdarMehish
- Original Message -
From:
Yechiel
Adar
To: Multiple
Title: RE: Purging Managed Standby Database Archive Logs
Hello Steve
If you are on 9.2 you can use utl_file.fremove directly
from the sql.
Yechiel AdarMehish
- Original Message -
From:
Orr, Steve
To: Multiple recipients of list ORACLE-L
Sent: Thursday, December 12,
Title: Blank
Load 5-10% of the stuff and see how much
it takes .
From this you can calculate.
No formula will give you accurate results, mainly because
actual field length vary so much that approximation is useless.
(based on a lot of years checking this)
Yechiel AdarMehish
-
Title: RE: DUAL
So listen up: For better April 1'st - add another
record to dual. That is known to cause a deteriorating effect on
developers.
:-)
Yechiel AdarMehish
- Original Message -
From:
Jeremy Pulcifer
To: Multiple recipients of list ORACLE-L
Sent: Monday,
Hello
After building a table the import builds constraint and indexes.
If you got a big table that can take awhile.
Check with task/performance monitor if the instance is idle or working.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED
automatically switching
from one to the other in case of failure (not clustering))
I will think about moving it to the users.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 17, 2002 2:08 AM
Happy Holidays Everyone
Shame on you Ruth. Paper ???
select sum(my data) from Rman_tables;
Really, Paper That archaic method of cutting trees and using them :-(
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, December 16, 2002 10:14 PM
Forgot to mention: OS - WIN/NT-2000
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 17, 2002 9:23 AM
I am currently busy with the same project. Junk tnsnames.ora for OID.
I installed OID 9.2.0.1.
I
Chicken feed.
Only 100,000,000$
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 17, 2002 5:13 PM
http://www.computerworld.com/hardwaretopics/storage/story/0,10801,76748,00.h
tml
Enjoy :)
- Kirti
Thanks Jesse
I am going to start it with 9.2.0 so hopefully it will be better.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 17, 2002 8:44 PM
Yechiel,
We weren't able to get OID replication to be stable
DUAL
Yechiel AdarMehish
- Original Message -
From:
Farnsworth, Dave
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, December 18, 2002 4:19
PM
Subject: RE:
EDOUARD, EDOUARD, EDOUARD
HELP!
-Original Message-From: Edouard Dormidontov
I do not get it.
If you put the tablespace in backup mode and then use the os utilities to
copy the datafiles to tape why you can not use then for recover. Just
restore the datafiles and the archive logs and do recover?
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients
Oracle 9.2.0.1 on NT:
Demo files 80MB.
Starter databases - 300MB
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, December 19, 2002 5:09 PM
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED
Hello Joe
Just schedule another backup of the archive logs 1
hour (or 5 minutes) after the regular backup. NetBackup will take a second
(complete) backup of the archive file and when you want to restore , restore the
last copy of the files.
Yechiel AdarMehish
- Original Message
42
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, December 19, 2002 6:45 PM
and the result is...?
reply of course only if it pertains to oracle :-)
Igor Neyman, OCP DBA
[EMAIL PROTECTED
Shao
We operate of the principle of GIGO - Garbage In, Garbage Out. The people on
this list expect you to write clear questions if you want clear answers.
Sometimes a questions like yours allow us to horse around a little. All in
good will and between friends.
Yechiel Adar
Mehish
- Original
')),'MM/'),'DD/MM/'),'D') FIRST_DAY
from dual) ,
(SELECT TO_CHAR(TO_DATE('07/12/2002','DD/MM/'),'W') CUR_WEEK FROM DUAL)
;
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, December 19, 2002 7:59 PM
Dan
The only thing missing are the Hostess Twinkie wrappers.
So, put your wrappers there to make it perfect.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, December 19, 2002 8:52 PM
Long live Dilbert!
The scary thing
the database.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, December 20, 2002 8:48 AM
I received ORA-04031 while exporting database. Can someone explain what
causes it and how to fix it?
. exporting post-schema procedural
to update the
stock on hand.
Afterwards process a commit and you got stock on hand = 0 despite the fact
that you have it in the warehouse.
You must check that process b do select for update or does the update anyway
without checking the stock on hand field.
Yechiel Adar
Mehish
- Original Message
Hello Stephen
We are in the process of converting the use of tnsnames to oid.
Just yesterday, Deborah from Oracle Israel was here and created
replication environment, with failsafe between two oid servers.
You can contact me directly if you want more details.
Yechiel Adar
Mehish
- Original
type is char.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 24, 2002 7:48 AM
Guys,
i want to export table data into a CSV file.
i am using the script below to do the same
to
me.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 24, 2002 5:33 PM
select pid from v$process p,v$bgprocess b
where b.paddr = p.addr
and name = 'PMON'
then oradebug wakeup n.
where n
string from tnsnames.ora.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, December 26, 2002 7:28 AM
Hi All,
I have installed Oracle 8.1.7 on Win 2000 server. I am able to
connect
to the server from a Oracle client
and had to delete all the leafs one by one.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, December 26, 2002 9:34 PM
Friends,
I need help with OID as I am new to it. How do I
delete a subtree (recursive delete) from DIT
infile 'abcd.'
Yechiel AdarMehish
- Original Message -
From:
Krishna
Kakatur
To: Multiple recipients of list ORACLE-L
Sent: Sunday, December 29, 2002 6:13
AM
Subject: Datafile with no extension using
sqlldr
Hi,
Oracle 8.1.7 on SUN Solaris 5.8
I
We are thinking about switching to this version on windows OS.
We use:
Rman
Advance replication
OID
Partitioning
Bit map indexes
Any pro / cons about this version?
The other option is 9.2.0.1.
Yechiel Adar
Mehish
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author
to it and then take the tapes out and move then to
another location.
Using this product save us the need to go to 100's of servers and remove the
tape from each one.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 31, 2002 7
in the aisles, we wish you a Happy Chanukah.
To those who have remained in their seats, we wish you a Merry
Christmas
Yechiel Adar
Mehish
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Yechiel Adar
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538
of the OID and created the Oracle
context under it, with each DB a separate entry. I do not have so many
databases that I need more then that.
BTW - if you want to access OID from 8.1.6 clients you must put the Oracle
context under some entry, not on the root.
Yechiel Adar
Mehish
- Original Message
Chanukah is a Jewish holiday that is celebrated about the same time as
Christmas.
It depends on the differences between the Jewish calendar and the Christian
one.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, January 06
that contain the branches
names.
On the fact table you have constraint: branch id must be in the branch
table.
When you import the fact table before the branch table all the records will
be rejected because the branch table does not have the ids yet.
Yechiel Adar
Mehish
- Original Message
Title: RE: Database/system Crashing
Got the same error on NT last week.
Check if there are system backups that backup the control
files.
When Veritas backup the control file as a regular file the
database can not write to it and you get this message.
Yechiel AdarMehish
- Original
I had some problems with stats pack install today.
There is: 'on error exit' in the scripts. Remove it so the script can
continue. This may solved your problem.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January 07
I think that you can try 2 things:
1) Run the function in the source db. Selects across links does funny stuff.
2) Write CSV file on the source system and sql loader on the target using
direct.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
I get around the connect problem by setting oracle_sid before invoking
sqlplus (no W) from a dos box in NT.
Of course, this means that I work on the server itself.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January 07
Title: How to create two db-links within one schema when global_names=true?
You can create as many dblinks as you want provided
that the dblink name is the same as the global name of the database you connect
to.
In your example:
Create public database link HR connect to HR identified by
David
The problem is that HR and SHIPPING are the same database.
I wrote to him offline saying that he needs to create a user that have
access to both schemas and use one dblink only.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent
an index
and you SQL reads too many blocks.
Use the BCHR as an indication. When it goes down it is time to check.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, January 13, 2003 5:08 AM
To add an example of what Anjo
on further checks and we
found more offending SQL's.
The BCHR has it's place.
Just do not measure yourself JUST by it.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, January 13, 2003 3:03 AM
Hmm,
Lately? That actually
301 - 400 of 505 matches
Mail list logo
