Hire a special company that handle this.
We are doing it to see how "unbreakable" are our servers.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, October 24, 2002 2:08 PM
>
> Hi,
>
>
Title: Flat file generation integrity ideas...
I do not see how the file can get
"scrambled".
You write it out ok.
The ftp is guaranteed.
So what is the problem.
I will go along with the suggestion to zip it. It saves on
the ftp time and also gives you some protection.
Yechiel AdarMehish
with
the DUL utility to help get the data out and rebuild the database.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, October 24, 2002 8:26 PM
> Hello All,
>
> I have heard several times that if the SY
Full import will rebuild the tablespaces.
browse the export file and you will see the commands inside.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, October 24, 2002 9:25 PM
> To do an import from a full ex
Where?
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, October 24, 2002 4:44 PM
Just a note that my new book Oracle9i RMAN Backup and Recovery (with
co-author Matthew Hart) is out now! Enjoy!
And remember,
Hello all
How can I run startup.bat file when database is up.
I tried using the HOST command in trigger but it does not work.
Something like: 'host d:\oracle\scripts\startup.bat' in the trigger.
Win2000, Oracle 8.1.7 or 9.2.0.
Yechiel Adar
Mehish
--
Please see the official ORACLE-L
to a
standby database.
Maybe this method can work for you.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, October 24, 2002 6:58 PM
> Could you use an external procedure or java call? Metalink & Tom Kyte&
new DB.
If I can decrease the initial extents then I will export and import the
whole schema and have enough space.
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
er analyze.
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 and web hostin
select add_month(sysdate,-7*12) from dual;
HTH
> Don't ask for details. That was 7 years ago. I don't even remember how
> old I was then.
>
Yechiel Adar
Mehish
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yechiel Adar
INET: [EMAIL P
But he was talking about sending, not receiving.
and he says that the ftp is assured to work ok.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, October 25, 2002 2:48 AM
> Unfortunately it is a trust issue...
are on windows check that values in the registery for oracle home.
Look for name=ora__pfile. The value points to the pfile.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Saturday, October 26, 2002 5:43 PM
> My query was
We had to decide the same thing.
As soon as I saw that support is down in 9 months I decided to go with 9.2.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, October 29, 2002 3:53 AM
> Thanx Joe.
> let me
Title: RE: List of Rows Updated
I think that it depends or the needs.
If you need a running log then auditing may me
better,
but if you need to find who has done what from time to
time
I think that logminer is better as it does not use
resources
all the time.
Of course, do not forget that log
Not a silly analogy - a very good one.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, October 30, 2002 3:29 AM
> As with any "cached" I/O subsystem technology (i.e. RAID-S, NetApps, etc),
> pl
Here is a message I found in my mail.
Change the:IF loc_username='TESTLOGIN' THEN RAISE kill_Login;
to whatever test you need.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, August 09, 2002
When you get files from an external source no amount of checking is enough.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, October 29, 2002 6:19 PM
Actually, I am sending and receiving files.
They will be ha
We have an OLTP system that I thought will benefit from first rows.
The sad fact is that when I set optimization to first rows the response
sucks.
Do some testing, as you can change this anytime.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EM
in a moment. So you get 1/1000 chance
to get wrong data.
Which odds will you bet on?
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, October 29, 2002 2:18 PM
List,
I'm always keen to refresh on database compa
That was exactly my point.
It is NOT 6 of one , half dozen of the other.
You commit 1000's of times for each rollback.
So the data you read is incorrect while you read it with enormous odds that
the changes will be committed.
Yechiel Adar
Mehish
- Original Message -
To: Mul
least, in the ADABAS way you are more correct then incorrect to the tune
of 1000's to one.
I just got steamed up because he called it "dirty" reads. To my taste they
are uncommitted changes.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L &l
Title: RE: Database Monitoring tool
Well, if you can not buy the books, write
them.
Yechiel AdarMehish
- Original Message -
From:
Anjo Kolk
To: Multiple recipients of list ORACLE-L
Sent: Saturday, November 02, 2002 5:58
AM
Subject: RE: Database Monitoring
tool
Hello Ian
I heard a lecture on raid 5 disks a few weeks
ago.
The rational behind read 5 being faster then raid 0+1 is
this:
You have 12 disks. In raid 0+1 you use striping across 6
volumes.
In raid 5 you strip across 11 disks, so you get almost
double the work without returning and moving
le-threading at the slowest part of the subsytem. While the stated
rationale surely sounds good for one user, what is the impact of such an
arrangement for a hundred concurrent users?
- Original Message -----
From:
Yechiel
Adar
To: Multiple
recipien
Hello Jared
BMC has a product that allow you to send reports to disk and then use web
access to browse the reports. I am sure that there are other tools that does
the same.
(disclaimer - this from a talk I had with one of our guys, no first hand
knowledge).
Yechiel Adar
Mehish
- Original
I heard that Oracle is shifting it's priorities
from Suse toward Red Hat.
Yechiel AdarMehish
- Original Message -
From:
Juan
Miranda
To: Multiple recipients of list ORACLE-L
Sent: Thursday, October 31, 2002 5:53
PM
Subject: Red Hat or Suse
Hello
R
on the drive.
Has anybody encountered this problem?
Do you know what can cause it?
What I need to do in order to prevent this from happening again?
Yechiel Adar
Mehish
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yechiel Adar
INET: [EMAIL PROTECTED]
Fat City
you will probably get a more specified answer.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, November 05, 2002 2:13 PM
> hi,
> can anyone suggestion w/c platform should i used to run oracle? wat are
the
are on 8.1.6 on NT and we do not use global names = true.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, November 05, 2002 4:53 PM
> Hello
>
> We currently have two Identical servers (identical in terms o
equence 4158
Current log# 10 seq# 4158 mem# 0:
D:\ORACLE\ORADATA\MUSK135\DATABASE\LOG10.ORA
Sun Nov 03 11:39:07 2002
ARC1: Beginning to archive log# 7 seq# 4154
ARC1: Archiving not possible: No primary destinations
ARC1: Failed to archive log# 7 seq# 4154
Yechiel Adar
Mehish
- Original Mess
the
archive log, like when the disk is full. Then the redo log will fill up and
the instance will stop.
After I connect as internal and do:
archive log stop;
archive log all;
archive log start;
everything is back to normal.
Yechiel Adar
Mehish
- Original Message -
To: <[EMAIL PROTEC
There is another view, DBA_2PC_NEIGHBORS.
Maybe there is some info there.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, November 05, 2002 5:58 PM
> On Tue, Nov 05, 2002 at 06:33:44AM -0800, [EMAIL PROTECT
ARCH (archive log stop; archive log all; archive log start;)
and the database continued to work.
Yechiel Adar
Mehish
- Original Message -
To: ORACLE-L <[EMAIL PROTECTED]>
Cc: Yechiel Adar <[EMAIL PROTECTED]>
Sent: Tuesday, November 05, 2002 8:17 PM
> Yechiel,
>
> No OS
version 5 to version 7
Propogating archive 3 destination version 5 to version 7
Propogating archive 3 state version 5 to version 7
Propogating archive 4 destination version 5 to version 7
Propogating archive 4 state version 5 to version 7
Yechiel Adar
Mehish
- Original Message -
To: Multiple
First rule: Do not mix OLTP and datamart.
Datamart access is very heavy and complex SQL's that will impact your OLTP
system.
I think that an NT with 2-4 CPUs and a lot of memory will do (a not so
educated guess).
Controller with a lot of cache memory and fast disks (15,000 rpm).
Yechiel
The list of 9i options can be found at:
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: Wednesday, November 06, 2002 4:49 PM
> I h
If I remember correctly ( a big if) there is an option in the OEM menus to
set the preferred credentials.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, November 06, 2002 5:04 PM
> Come on folks...Help
Hi Tim
We just signed a contract for external storage system from EMC and the
configuration is going to be:
Regular servers - connect as Nas
Database servers - connect as San.
If I remember correctly Nas use SCSI connections while San use fiber.
Yechiel Adar
Mehish
- Original Message
Hi Paulo
When creating an index, or CTAS, oracle use temp segments
while building and rename them after the build finish. So if you do not have
enough space you will get: unable to allocate TEMP segment.
Yechiel AdarMehish
- Original Message -
From:
Paulo Gomes
To:
Title: Adding more space to server
Is the server dedicated to Oracle data files or you
have more data in it.
We have for each server a lot of data that was loaded in
the database
+ a daily export.
I saved a lot of space by compressing the folders for the
data and the export.
Yechiel Adar
You do not need to change the primary key unless different user names can
have the same userid.
Just add a unique + not null constraint on the user name column.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, No
problems. There is a
reference to doc# 66320.1 in this document. The 66320.1 document will
explain to you how to change the character set. It worked for me in 8.1.6 on
NT.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent:
historical data so the structure will remain the same as in production.
We are doing it in ADABAS on the mainframe.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, November 07, 2002 11:24 PM
> Well, if worst
My guess will be that PHYRDS is the count of start i/o's. Each start i/o
read mutilblock_read_count blocks from the disk.
The data buffer that you read with each start i/o is the same: 8 blocks of
8k or 16 blocks of 4k. So you get the same number of start i/o's.
Yechiel Adar
Mehish
Title: sqlplus ~no~output
To do it in a command file -
@sfsfasdf.sql.
Set termout off does not work for commands executed from
the command line.
Yechiel AdarMehish
- Original Message -
From:
Markham, Richard
To: Multiple recipients of list ORACLE-L
Sent: Monday, Nove
Thanks for the link Jared.
For now, I just bookmarker it.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, November 13, 2002 3:23 PM
>
> Check out OraC, written in Perl of course. :)
>
> http://ww
I heard in Oracle Week in Israel that Oracle is planing to add Linux to
their supported products and provide help desk for it.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, November 13, 2002 4:48 PM
> You
Check what SP is installed on the server.
This is a common problem with Y2K SP1.
Upgrade to SP2.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, November 13, 2002 5:18 PM
All
Ive finally returned to my desk fr
Title: How-To or Good Practices on Code Releases
Whenever I install a new release of software my
boss wants to know:
How do you return to the old version if this does not
work?
For each install script require an undo
script.
We are using toad to compare schemas and it can also
generate s
have facts,
but having an opinion is an
art!
-Original Message-From: Yechiel Adar
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 13, 2002
11:04 AMTo: Multiple recipients of list
ORACLE-LSubject: Re: How-To or Good Practices on Code
Releases
Whene
No matter how you do it, do it in parallel.
Export and import, or CTAS, by schema or tables so you can run them in
parallel.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, November 13, 2002 7:03 PM
Qs What wo
Run your script at 23:58 :-)
Yechiel AdarMehish
- Original Message -
From:
Barbara
Baker
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, November 13, 2002 8:24
PM
Subject: OT ksh day of week
yesterday
Will someone take pity on this poor VMS'er l
Hi Bob
I took a look at the database service one of our servers.
service properties:
startup program: d:\oracle\ora816\bin\oracle.exe abcd (the sid of the
database).
startup mode = automatic.
logon as local system account.
allow service to interact with desktop.
Yechiel Adar
.
Yechiel Adar (who does not have any hidden/unhidden connections to DataBee)
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, November 13, 2002 9:23 PM
> one of the things I'm experimenting with right now, based on
Murphy say:
If you see some smiling when everyone else is panicking, you know that he
found whom to blame.
I told you so is nice, but YOU still have to deal with the result, correct
the scripts or perform rollback actions for scripts that are half finished.
Yechiel Adar
Mehish
- Original
.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, November 14, 2002 12:03 PM
> Hi all,
>
> A 3rd-party software vendor is coming in to install their application on a
> new Windows 2000 server. This appli
Put a copy of tnsnames where MS ODBC wants it?
Check if MS ODBC support name server or Directory services?
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, November 15, 2002 4:58 PM
>
>
>
>
> We a
that I know use DB2. I
have not heard of anyone using Oracle on mainframe (at least under IBM MVS).
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Saturday, November 16, 2002 12:24 AM
> I just found out today that
does not do recovery. You need to restore the archive logs
that you think you need and then do recovery yourself.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, November 18, 2002 12:23 PM
Is no-one out there
Thanks for a clear and illuminating article;
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, November 18, 2002 7:08 PM
> One thing my article did not cover was of course the
> possibility that you end wi
rent job the archive log that were created during the backup.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, November 18, 2002 12:23 PM
Is no-one out there using NetBackup???.
Without wishing to sound rude
if my questions are somewhat trivial but we need a decision tomorrow
morning (in 18 hours) as they start doing some training session on the
system on Sunday and time is short.
TIA
Yechiel Adar
Mehish
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yechiel Adar
INET
We just bought EMC Cellero.
I do not know the reasons, just that they won the contract.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, November 19, 2002 8:49 PM
> Hi All,
>
> We are considering the
We just bought EMC Cellero.
I do not know the reasons, just that they won the contract.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, November 19, 2002 8:49 PM
> Hi All,
>
> We are considering the
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 -
To
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 h
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 (
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 and
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 h
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
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 o
: 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: Th
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
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 AdarMeh
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 a
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 A
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 <
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 w
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
> H
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
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
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 bac
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 c
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.
Yec
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
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
> Solar
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: T
.
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 win
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?
&g
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, De
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
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
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 PROTEC
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
ag
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
201 - 300 of 524 matches
Mail list logo