Hi all,
I need to move some sql server tables to oracle.
Do you have some ideas how to do it. I have no idea ...
rgds
GWant to chat instantly with your online friends? Get the FREE Yahoo!
Messenger
Hi G (10? scnr),
if it's really about some tables
I would spool them to a flat file
and use sql loader to 'import' them.
Or use the Oracle Migration Workbench.
hth,
G(uido)
[EMAIL PROTECTED] 18.09.2003 09.59 Uhr
Hi all,
I need to move some sql server tables to oracle.
Do you have some
Hi Gunner
You can push data from the sql server via DTS (Data transformation
services) or
pull the data from the Oracale database via (Heterogeneous services)
Gunnar Berglund wrote:
Hi all,
I need to move some sql server tables to oracle.
Do you have some ideas how to do it. I have no idea
You
can always use the SQL Server DTS package to do this.
Dave
-Original Message-From: Gunnar Berglund
[mailto:[EMAIL PROTECTED]Sent: Thursday, September 18,
2003 3:00 AMTo: Multiple recipients of list
ORACLE-LSubject: Move SQL Server Tables to
Oracle
Hi all,
I
To get the 10053 trace, you will need to reparse the query - you might
have
to flush the shared pool or perform other shared sql invalidations (such
as
I normally just modify the query to have comment /* test1 */ or /* test2 */
etc. in it. That way it's easy to search from possibly long 10053
Heh, strangely, this kind of idea of freeDUL (or whatever) has been also in
my mind for couple of years, I planned to write it in C, but since I'm lazy,
I've not got past of planning phase :) Anyway, keep up the good work and
if your source happens to be free, put it up somewhere allowing others
It also can be caused by bad sectors or other hardware errors, but I'd bet
on sparse file problem as you described.
When I create temp tablespaces, I either copy the tempfile into another
filename and then rename to original using cp, that way the file isn't
sparse anymore, thus no problems using
Heh, look what happens if you try to help someone ;)
(an automatic reply to my message)
---
Trend SMEX Content Filter has detected sensitive content.
Place = Multiple recipients of list ORACLE-L; ; ; [EMAIL PROTECTED]
Sender = Tanel Poder
Subject = Re: Tempfile weirdness
Delivery Time =
You raise an interesting idea in my mind...
How useful would it be for us if Oracle created an INFINITE_DUAL table -
One where you could select as many rows as you wished. I guess it might
be
dangerous but it would at least be very efficient if Oracle coded it as a
special table. Then you
Hi!
If even Oracle hasn't seen this error, then probably we can't help much here
either. Just a wild guess, try to move this partition to another location
and select from it then (although koxsisz1 isn't a data layer error as far
as I understand). Try to read using index if available, then using
Hi Tanel,
A free DUL in C would be very nice to have and to study the source code
of. maybe you should also contact Kurt van Meerbeek of jDUL project on
sourceforge, maybe you have some ideas or info he doesn't have that
could help his efforts or of course Richard's efforts.
kind regards
Pete
You do not need two addresses.
The parameter address_list really means what its name applies. You can have
two addresses in a single listener. Just put in the host= the tcp/ip address
of each network card.
The same applies also to tnsnames.ora. You can write two addresses in the
address_list
There are DUL?s manual.
http://www.fors.com/velpuri2/dul_ucg8.html
May be interesting for someone.
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de
Pete Finnigan
Enviado el: jueves, 18 de septiembre de 2003 13:55
Para: Multiple recipients of list ORACLE-L
In this example, yes, looks like you need a union.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 18, 2003 12:44 PM
Perhaps this small example can make it clear?
I have two tables, orders and order_to_delete.
I want to find
We have had an ongoing problem for nearly 1.5 years now starting with
8.1.7.3.2. If we patch the Oracle Apps 11i, a majority of the time, the
oracle.exe process gets a runaway thread. A thread exists in the
oracle.exe but not in v$process/v$session. Shutting down the database does
not
Title: IBM AIX 32-Bit
Hi there!
I got a question: Can I run Oracle 64 Bit on IBM AIX 32 Bit?
I know that AIX 64 Bit can run either Oracle 32 Bit or 64 Bit.
Does it also work the other way round?
Thanks,
Helmut
Yeah, I got that too.. I did not have in my post any of those words you mentioned.
- Kirti
--- Tanel Poder [EMAIL PROTECTED] wrote:
Heh, look what happens if you try to help someone ;)
(an automatic reply to my message)
---
Trend SMEX Content Filter has detected sensitive content.
Wouldn't something like DUL need to read Oracle's dictionary? My impression
is that a lot of stuff in the data files is heavily encoded, like date and
number formats. Wouldn't you need the dictionary to understand where one
column stops and the next starts, and maybe even where one row ends and
Call Oracle Support ;)
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 18, 2003 3:39 PM
There are DUL?s manual.
http://www.fors.com/velpuri2/dul_ucg8.html
May be interesting for someone.
-Mensaje
Metalink Note # 225551.1 'AIX - 32bit vs 64bit' will explain what is supported and how
to do it.
- Kirti
--- Daiminger, Helmut [EMAIL PROTECTED] wrote:
Hi there!
I got a question: Can I run Oracle 64 Bit on IBM AIX 32 Bit?
I know that AIX 64 Bit can run either Oracle 32 Bit or 64 Bit.
Hi!
Orakill is able to kill threads based on thread id. But
since you can't find out the "runaway" thread id-s from v$process, you could
find all thread id-sin oracle.exe, minus those spids which exist in
v$process and kill those. But I definitely recommend to turn to support first,
At the recent OW conf, Oracle folks did announce that Oracle10g will support TTS across
platforms/OS. No word on any data extraction tool as you guys are discussing here.
- Kirti
--- Richard Ji [EMAIL PROTECTED] wrote:
KG,
Yes, if Oracle start to address this, then it will be pretty hard
Btw, if you're applying bigger patches, you have shut
downAppsanyway, shutting down the database service for a sec
doesn't add much downtime...
Tane.
- Original Message -
From:
Tanel
Poder
To: Multiple recipients of list ORACLE-L
Sent: Thursday, September 18,
Hi All,
I'm new on this list and need help on tuning the following query. I hope the gurus on this list will help me with ideas so that I can attack the problem with a much wider knowledge.
I'm providing you withall the details i can manage now, but 10046 trace data is not available since we
Aha, I found it in OP :)
Is this another one of those spiffy cool things in Oracle that are just
something else to go wrong and make life a bitch?
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 18, 2003 4:39 PM
Yeah,
We know the
thread id from running pslist from sysinternals.com. Orakill will not kill
it probably since doesn't think it really exists.
[EMAIL PROTECTED] 9/18/03 9:49:41 AM
Hi!
Orakill is able to kill threads based on thread id. But
since you can't find out the "runaway" thread id-s from
Nah... I think it was the...
something else to go wrong and make life a bitch?
In the original post... Looks like the scanner looks at the entire
message...
Tim
-Original Message-
Sent: Thursday, September 18, 2003 9:40 AM
To: Multiple recipients of list ORACLE-L
Yeah, I got that
Well, have you tried it?
In my understanding orakill is actually an OS thread
killer written by Oracle, it just searches the appropriate oracle.exe based
onSID and killsthe thread with OS threadid in it. It does
notlog on to Oracle to check whether Oracle knows anything about this
thread
Hi,
How many CPUs do you have on your machine? I assume not 32 - perhaps
reducing the degree of parallelism might help (less is sometimes more).
How much memory do you have on your machine? I suggest fixing your virtual
memory paging problem first - do this by resizing areas like the buffer
Tried it a number of times.
Lately Oracle has us run a MS utility to take "hang dump" but no answers so
far. "Tanel Poder" [EMAIL PROTECTED] 9/18/03
9:17:17 AM
Well, have you tried it?
In my understanding orakill is actually an OS thread
killer written by Oracle, it just searches the
Hello
Wondering about this. If backing up the database with RMAN in NOCATALOG
mode.
When would be the best time to do backup of the controlfile? Before backup /
after backup /before and after backup.
Does this aid your recovery from a crash? What advantage would it have?
Many Thanks
Regards
Craig,
Just out of interest, what type of application is running on the
database? I was just wondering why you were not using the plan stability
features in 8i on your production database.
Regards,
Craig Munday.
At 05:45 AM 2/06/2003 -0800, Craig Healey wrote:
OK, I'm confused. Maybe it's
Denham
Whether you need to back up the control file depends on whether you can
recover the database without it. On Oracle8i, I gave up trying to extract
the controlfile from the RMAN backup, and simply back the controlfile up
after the backup completes. Others on this list have reported they
Title: RE: Anyone have a copy of DUL ??
at about 10K/hr make sure you have PO on hand. From what I have heard, they install, work and de-install. You just get to see the end result.
If you can get DUL copy, you could also send email to uncle Larry and ask for Oracle source code.
Raj
Hi Listers,
I followed the Note:118409.1 Creating a standby database using rman.
The production database is ADVDMO7 on harrier unix box.
The Recovery catalog is ADVDMO on harrier Unix box.
The standby database is STANDBY on hawk Unix box.
The production db is in open status. I did rman full
Title: RE: Anyone have a copy of DUL ??
probably not, in absence of DD it will probably dump column id and table ids and rowids. If you dump a block, you will see that column length is also stored to indicate how many bytes to read.
Raj
-Original Message-
From: DENNIS WILLIAMS
We are trying to install 9iAS 1.0.2.2.0 on a Dell Poweredge 2650 / P4 2Gig, we have
succesfully installed this software in older model machines. When we try to run the
installer from the distribuition media we get an error that the installer did not run
because it was probably aborted and to
I do it but there say don´t have DUL
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de
Tanel Poder
Enviado el: jueves, 18 de septiembre de 2003 15:50
Para: Multiple recipients of list ORACLE-L
Asunto: Re: Anyone have a copy of DUL ??
Call Oracle Support ;)
It's so much easier to include an sql alter database backup controlfile
to filename;
in the rman script.
Backup the Database first.
Then backup the archive logs.
Then backup the controlfile.
Hemant
At 06:54 AM 18-09-03 -0800, you wrote:
Denham
Whether you need to back up the control file
Hi,
If I remember correctly MMLs like Veritas and/or Legato let you rebuild the
indexes if you have the tape in hand - It can be slow but I thought it
could be done.
Regard,
Craig.
At 09:46 AM 8/05/2003 -0800, Stephen Lee wrote:
One consideration with MML if this is a case of a tornado
Hi!
Yes, you have to start from very beginning, you have be able to decode
number date columns, have to know internal row structure, block structure,
be able to find the start of tab$ and clu$, you have to be able to read
extent maps from segment headers (in LMT you don't have anything in uet$
Hi Juan,
There are some interesting papers on the rest of this site as wqell if
you scroll around the directories.
kind regards
Pete
--
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see
- --- Original Message --- -
From: New DBA [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Thu, 18 Sep 2003 05:59:37
Hi All,
I'm new on this list and need help on tuning the
following query. I hope the gurus on this list will
help me with ideas
Sort of OT, but it is Oracle information related: Veritas has taken over
http://oraperf.com I don't know if this is good, bad, or indifferent, but
it's a change that I thought some might find interesting.
Or not.
Rich
Rich Jesse System/Database Administrator
[EMAIL
A backup controlfile allows me to do Point-in-Time or Incomplete Recovery.
This I have to do when
a) I am cloning a database from a Hot Backup and cannot afford to shutdown
the source database to copy the active controlfile and online redologs
b) If I have lost ALL my files in the source
And I guess the hidden text feature doesn't work.
-Original Message-
Sent: Wednesday, September 17, 2003 2:50 PM
To: Multiple recipients of list ORACLE-L
Have a laff! See Note 240863.1 (esp the first sentence). This seems to have
been around since 11-Jun-2003 (if the Modified date can
Indeed, the row directory is in the block header.
And like Raj said, there is a length value to tell
you how far to read. The values are encoded in Oracle's
internal format, such as the 7 bytes coding for Date type.
Richard Ji
-Original Message-
From: Joe Testa [mailto:[EMAIL
Regular blockdump interprets the result into human readable format.
However, if you set event 10289 at level 1, you'll have hexdumps instead
can continue from there :)
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 18,
They give DUL only for big money for customers with big problems (e.g. not
solvable otherwise)
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 18, 2003 6:04 PM
I do it but there say don´t have DUL
-Mensaje
Dennis, i dont think those 2 items you mentioned are that encoded, using
the dump command you can see how they are stored.
joe
DENNIS WILLIAMS wrote:
Wouldn't something like DUL need to read Oracle's dictionary? My impression
is that a lot of stuff in the data files is heavily encoded, like
I always backup the controlfile as a separate statement AFTER the back
is done so hopefully the backup i just completed is in there :)
joe
Denham Eva wrote:
Hello
Wondering about this. If backing up the database with RMAN in NOCATALOG
mode.
When would be the best time to do backup of the
Hello,
I am running oracle on Linux as my development server. Somehow, the hard drive
crashed last night. When I run fsck on the partition that has the oracle
installation and oradata, it always failed with all kind of stuff
(Bad/Duplicate block, short read block, etc), so I assume fsck cannot
The modified date is unreliable. I have seen notes relating to 7.3 and 8.0
and Apps 10.7 which, from the text, I know have *not* been modified for two
or more years
and yet the modified date appears as being only a month ago --
particulary Desupport Advisories.
e.g. see Note 39013.1 -- The
(Resending)
Any comments on the following??
When creating index, got
ORA-00603: ORACLE server session terminated by fatal error
apparently caused by
ksedmp: internal or fatal error
ORA-01114: IO error writing block to file 121 (block # 149)
ORA-27063: skgfospo: number of bytes read/written is
We run multiple instances on the same server. My understanding is max_parallel_servers
should be set to 4 x CPU. We have 4 CPUs which means 16.
however, does this take into account multiple instances on the same server?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
I remember the command window that opens and doesn't do anything.
closing it manually is what I was told so the install can continue.
I think their were also some places where it opened windows behind the installer,
minimize the installer or check the task bar.
Tanel, Richard
That was what my innocent question related to. I had played with LogMiner
without a dictionary and it was challenging. Naturally with a program you
can take care of some of those issues in the program. Anyway, from the
replies this sounds feasible and probably really useful.
Sorry about the last post. Forgot to change the subject. Duh!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and
This means that the program needs to either be relinked or the LIB_PATH
variable is pointing to the wrong directory. This error usually turns up
when you have 32-bit and 64-bit libraries on the system and one of them
must be first in the LIB_PATH. Determine if the program was compiled with
a
1) it's Field Support not Tech Support that has it
2) Oracle does not sell nor does it release the code for DUL. A field
support technician comes to your site, installs it, runs it and removes
it. You pay a fee for this. when I used it (in '98), the fee was $5k
per every 8 hour period, with a
Stephen,
I had something similar happen to me. In 8i, Temp files are not fully
allocated when they get created. So if you create a temp file of 600M, only
a small portion gets immediately allocated. The Temp file grows into the
full 600M as needed. They did this to speed up the creation of
We have new SUN V480 with SAN 6820 will arrive soon.
I like to get some
information about how to format, partition SAN 6820.
This SUN 6820 SAN is
dedicate for ORACLE database to use and we want
partion and format it best
for ORACLE to use. ANyone has information ?
Thanks.
Btw, how much free space do you have in OS where your tempfiles are?
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 18, 2003 6:49 PM
(Resending)
Any comments on the following??
When creating index, got
ORA-00603:
For a critical database where I want to be SURE that the file system has
enough space for the
TempFile, I run a large
SELECT * FROM DBA_SOURCE
UNION
SELECT * FROM DBA_SOURCE
UNION
One problem I see with giving this away free is that you will be supplying
a tool that allows you to extract data from the database, bypassing all
inbuilt security. A BIG no no. I suppose that also applies to this kind of
tool even under a paid license structure.
How many of you would shout at
Title: RE: oraperf.com is now Veritas
I noticed that when I read Anjo's paper at OOW ..
Raj
-Original Message-
From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 18, 2003 11:30 AM
To: Multiple recipients of list ORACLE-L
Subject: oraperf.com is now Veritas
I suggest you to split it in half, with an axe preferably.
Ok, seriously, don't you think it would be useful if you described how many
which sized disks you'll have in your array, what will the nature and size
of your DB be?
Tanel.
- Original Message -
To: Multiple recipients of list
There is no simple magic formula how many parallel slaves you should have.
It all depends on your CPU and IO utilization. Yes, utilization, because if
your CPUs or IO are running at their limits already, you won't benefit from
parallel execution at all. In fact PX may make the situation even
Hi!
Denham
Whether you need to back up the control file depends on whether you can
recover the database without it. On Oracle8i, I gave up trying to extract
the controlfile from the RMAN backup, and simply back the controlfile up
after the backup completes. Others on this list have
__
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--
You can't bypass Oracle security (well if configured and patched well) from
remote with any tools (at least I surely hope so that there wouldn't be any
backdoors). There is no magic tool which can log on to Oracle without
password from remote and start scanning all the datafiles. This DUL works
Hi Juan
For which platform do you want it for?
Not saying I have it! ;-)
ta
tony
At 12:19 AM 17/09/2003 -0800, Juan Miranda wrote:
We need
to extract the data of a datafile directly, because we don´t
have
the rest of the database (other tablespaces,
controlfile, etc).
Are there some utility
At this moment it's 13 Gig. The tempfile was created as 5 Gig, but since it
remained unused, it didn't grab any significant disk space. It's possible,
that at some time, the free space in the file system fell below 5 Gig. When
I tried to create the index, the error occurred immediately. So,
Karniotis, Stephen wrote:
Does this help everyone understand what we are looking for? SUBMIT SUBMIT
SUBMIT
shuffling and cringing
Yes, master. Whatever you wish, master.
Thank You
Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (313) 227-4350
Mobile:
Mark,
I see what you are talking about, but my developers don't have access
to data files. Heck, I don't have access to data files in production.
The production DBA controls the account.
I totally agree that a tool such as this in the wrong hands can be
very dangerous, same thing applies for
Hi Mark
I agree with you Mark, even if its supplied by Oracle technicians - it
is as you say possible to by-pass security completely. Does anyone in
Oracle check that the field support personnel dispatched to a site ( in
urgency ) are dumping data for the owner of it? -
I covered the issue of
Well if they can hack at it with Perl it's not really the tool that's
the problem and preventing access to the tool is not a solution.
-Original Message-
Sent: Thursday, September 18, 2003 10:35 AM
To: Multiple recipients of list ORACLE-L
One problem I see with giving this away free
Hello
List, I am running into weird dbms_job issue. I have a dbms_job to collect
perfstat every 1 hour , job was running fine for last 8-9 months without any
issue. For last 3 days job is stopping every night around 2 AM. I amnot
seeing any trace file, any logs in alert file. Any idea what
The error was first discovered when we tried to move a partition. ( alter table
archive_wave_i move partition SEP1103 tablespace CHANARCH_NLC_2003_09_DATA). The
table was renamed to OLD_archive_wave_i once it was determined that no new varray data
was accessible. My theory is that this is
me too. learned this from testing Rman back in 8.1.6. plus, you need this
control file to recover from to get as late (most recent) timestamp as
possible for recovery purposes.
-Original Message-
Sent: Thursday, September 18, 2003 11:45 AM
To: Multiple recipients of list ORACLE-L
I
Hi,
I have hit similiar situation in my datawarehouse server. As temp file
are sparse, it did not allocate the actual space when it was created.
But as you really begin to sort and the filesystem is full , you can get
this error. I offlined that tempfile and add another tempfile in another
Re-submit the jobthat should work
It has a long theory!!
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Thursday, September 18, 2003
11:00 PM
To: Multiple recipients of list
ORACLE-L
Subject: dbms_job issue.
Hello
Tom,
Your observation on which platform? On HPUX 11.0 I think it allocates full
given physical size of tempfile at the time of creation and it was 8.1.6.2
when I created it 2 years back. I remember that I created 6 files of 501 MB
each and it occupied disk space of 3GB+.
Regards
Rafiq
You said for the last 3 days,
so what do you do to get it running again?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Thursday, September 18, 2003
12:30 PM
To: Multiple
How many control files you have? try to remove it from your initSID ora and
start again. Try to remove one by one, if you have more than one
controlfile. Otherwise restore it whole cold back up if you have.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
hi all.
i have two databases running oracle 817 on different
machines (AIX 4.3). I am trying to connect to these
databases remotely from my desktop. when I use the
SERVICE_NAME = in the connect_id for one of the
databases, I get ora 12500 error. When I replace it
with SID= everything works
Rafiq,
SunOS 5.8
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, September 18, 2003 1:40 PM
To: Multiple recipients of list ORACLE-L
Tom,
Your observation on which platform? On HPUX 11.0 I think it allocates full
given physical size of tempfile at
Already tried to resubmit it twice, everytime its breaking around mid
night.
-Original Message-From: Venu Gopal
[mailto:[EMAIL PROTECTED]Sent: Thursday, September 18, 2003
10:40 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: dbms_job issue.
Re-submit the
Hi Pete
I have used Dul many times at customer sites when I was employed by
Oracle Denmark.
Every time the customer management had to verify by phone and fax that
they understood
the full impact of using Dul.
Oracle have disclaimer that explains the problems with missing
transaction
Hi all
Been trying to get www.oraperf.com (oraperf.veritas.com ) to
resend my forgotten password as well as new registration on the site
but am not getting any email from them.
I need to try something out in the next day and would appreciate
it if someone could provide me with an account and
IIRC
it is a bug, on 5L oracle sometimes _forgets_ to run the job. We noticed this in
early versions of 9i. We stopped using it and we use cron
instead.
If you
want to test this, set job_queue_processes to say 20 and see, it will probably
work. The workaround from oracle states to set it
Resubmit it and it runs fine until mid night. So I really dont have any
stats for this week.
-Original Message-From: Igor Neyman
[mailto:[EMAIL PROTECTED]Sent: Thursday, September 18, 2003
10:45 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: dbms_job issue.
Hm, it's strange.
When you create a temp datafile there is some data written to it despite you
actually store anything there or not (headers or whatever control structs).
So, the tempfile is being used from beginning. The mechanism of creating
sparse files is quite simple: just forward seek
Title: FAO: Peter Gram
Sorry list ...
Pete,
your email has again gone secure
Raj
This e-mail
message is confidential, intended only for the named recipient(s) above and may
contain information that is
i know there are no magic formulas, but im hoping for something better than trial and
error. i would assume that parallel query helps most when:
1. are doing work off of multiple mount points.
2. Have alot more LIOs to perform than PIOs(such as sorts).
am i close on this?
From: M Rafiq
To use service_name, make sure that you have defined local_listener and service_name
in init.ora file.
-Original Message-
Sent: Thursday, September 18, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L
hi all.
i have two databases running oracle 817 on different
machines (AIX
Juan
I have the URL that you can get a copy from but you
need access to Oracle's network. Wrote about it in Select
Journal.
In 1999 - I wrote:
DUL - Data recovery
UnLoader
DUL or Data recovery
UnLoader is a utility that that will generate either a data file or an
Oracle Export file by reading
Hi, guang:
Another possible solution is like, just similiar. You can individually drop
tempfile from temporary tablespaces, not like datafiles.
SQL create temporary tablespace tmptest tempfile '/home/oracle/tmp1.tmp' size 30m;
Tablespace created.
SQL alter tablespace tmptest add tempfile
What DBA, in their right mind, is going to give any user or developer
file level access to their datafiles? That is what user and group
permissions are there to restrict. All our db's have 600 level file
permissions for oracle user access only. If we have to bring someone on
site for using a
Peter,
I used DUL (one of my last 40 hour days) under extreme urgency. We
didn't have to fax anything, but then, our senior Vice President did
call Ray Lane's secretary to get Field Support to pull someone in off
vacation to come to our site, so I guess that's pretty good
verification.
The
1 - 100 of 168 matches
Mail list logo