put your userid and password and all other parameters in parfile and run.
exp parfile=abc.parfile
It will hide your password on unix level. your password file should be
readable by you only...
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]
Do a
"dd" on unix and change the contents of any particular
block.
-Original Message-From: novicedba
[mailto:[EMAIL PROTECTED]]Sent: Thursday, May 31, 2001 2:16
PMTo: Multiple recipients of list ORACLE-LSubject: How
do I corrupt a block
hi,
This may sound funny. I wa
Add some new ones, drop the old ones...
hth
connor
--- Nirmal Kumar Muthu Kumaran <[EMAIL PROTECTED]>
wrote: > hi dba's,
>
> In my DB, oracle 816, NT4, the redolog member's
> size is only 50kb. I'm
> having only two groups with a single member each.
>
> I tried with alter database command, t
"CHAN Chor Ling Catherine (CSC)" wrote:
>
> Hi Gurus,
>
> How do I create 2 unique indexes (STDID,PAYGRP) and (ACCTNO,PAYGRP) on the
> same table ?
>
> I created the first index successfully but encountered the error "ORA-01452:
> cannot CREATE UNIQUE INDEX; duplicate keys found" when I tried t
OiD is a "separately licensable product"...not included as part of the DB
license. If I remember correctly, you have the UPU license calculation or a
per entry license @ $50/, with 5000 entries being the minimum!!
Ed Haskins
Oracle DBA
Verizon Wireless
-Original Message-
Sent: Thursday
Hi Tracy,
Oracle still won't let you do a fast refresh if the
creation time stamp on the snapshot log is more recent
than the creation time stamp or last complete refresh
of the snapshot. An attempt to do so will generate
the dreaded ORA-12004: "REFRESH FAST cannot be used"
(see note 1035524.6 "
HELP
I have no sense of humour
: )
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
From: Gary Weber [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 4:50 PM
To: Multiple recipients of list ORACLE-L
Subject:
Hi,
Actually, it's not so bad.
OiD is licensed separately ONLY when used as general purpose directory
service.
Check Metalink Note:135696.1
"13. Do I need to license OID when deploying the directory for NET8 ?
Answer
--
No, deploying OID for NET8 is free of charge."
Vadim Gorbounov
Oracle
Ken,
(FYI, I used a version of Apache (1.3.12) that came from Apache's web site,
not the version that came with Oracle. And my web servers and database
servers are on different machines. And my web servers are running Kerberos
and SSL. And I still can't believe it all works together.)
Check A
Jared,
Yes and No. As I understand them it uses both a merge and a hash join, but
then you know marketing types!! BTW: that was a guess on my part too. And yes,
I do need to RTFM to be sure.
Dick Goulet
Reply Separator
Author: Jared Still <[EMAIL P
SET ORACLE-L DIGEST
=
Hamid Alavi
4268 Flintlock LN
Westlake Village 91631
PH: 818-8790966
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
--
Please see the official ORAC
Kevin,
You did not state the OS you will be using. If it is a flavor of LINUX them 3ware
makes a ISA card that will handle disk drives like they were SCSI drives. You save the
high cost of disks and spend it on the card. But I bought 2- 40 GIG WD drives last
week for $109.00 each and put them i
The docs actually do a good job of showing what the explain plan
will look like for a partition elimination.
Look at the 'Explan Plan' chapter of 'Designing and Tuning for Performance'
Are you using ?/rdbms/admin/utlxplp.sql to examine your explain plan?
Jared
On Thursday 31 May 2001 09:00,
Just to be more specific, the product you'd look for is the "Oracle
Accelerator" for Kintana, see the URL here
http://www.kintana.com/products/accelerators/oracle_technologies/oracle_technologies.htm
Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC 27560
VM: 9
By the way ... For your own sake . never use data files that big
!!My personal opinion is multiple files of 500 Megs or less . Or, on a
system that has a file limit, 1 GB files as a Max. Larger than that and
you can have problems with backup software long running FTPs if yo
Jeremiah,
Thanks -- I knew someone would know better than me how to do this! Another
post to save for when I get to have a standby db again :)
Rachel
>From: Jeremiah Wilton <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject:
On our old AIX system we had to set a system parameter for the file system
that allowed us to have files bigger than 2 GB. I do not know if your
system has something like that.
-Original Message-
Sent: Thursday, May 31, 2001 2:29 PM
To: Multiple recipients of list ORACLE-L
What do you
You mean like the programmers of the Oracle Applications? What would we
need for that, a missile?
(What kills me is that, they don't use declared foreign key constraints in
the database. Presumably, since the code base is so old, if they
introduced them now everything would break. You'd think
On Thursday 31 May 2001 06:41, [EMAIL PROTECTED] wrote:
> I wonder if their thinking of the star join??
>
> Dick Goulet
Isn't that actually just a sort merge?
Just guessing here, didn't RTFM.
No flames please! :)
Jared
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author
Title: RE: OT: Archiving not possible with SQL Server?
I protest Jared's removal from the list for telling jokes! Henry please reconsider! :)
--Chris
[EMAIL PROTECTED]
-Original Message-
From: Gary Weber [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, May
Hello,
sorry for this OFF-OFF-OFF... topic question.
I'm looking for a counter which counts all visited pages, not just
current page visited.
thanks...
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Danisment Gazi Unal (Unal Bilisim)
INET: [EMAIL PROTECTED]
Fat
There is a massive concern here about the cost of Toad. Since it is so
high we have been forced to get only a few licenses only give it to the most
prolific users. This is the pits !
If you have an alternative I would ABSOLUTELY APPRECIATE any information you
have on it !!
Kevin
-Origina
OK .. Never is a harsh word.Depending on your environment and in
my opinion based on the environments I was in I still say never.
-Original Message-
Sent: Thursday, May 31, 2001 3:31 PM
To: Multiple recipients of list ORACLE-L
Never say never :)
I opted for 4 GB files
Merhaba,
If aggeragate=false, which is not default, SQL statement length does not make sense
since each SQL are same lenght in raw file and
output.
in addition to Ed, check your output. If there ara a lot of kernel calls such as
parse,fetch, etc. row file will be larger than output.
regards.
Hello, Richard,
If you want to use NOLOGGING operation on primary database, this is
still possible to keep STANDBY in sync. Regularly check output of
select FILE#, UNRECOVERABLE_CHANGE# from v$datafile;
on primary and standby database, and , in case UNRECOVERABLE_CHANGE# on
On Thu, 31 May 2001, Kevin Lange wrote:
> By the way ... For your own sake . never use data files that big
> !!My personal opinion is multiple files of 500 Megs or less . Or, on a
> system that has a file limit, 1 GB files as a Max. Larger than that and
> you can have problems w
Title: RE: select question
> -Original Message-
> From: Ron Rogers [mailto:[EMAIL PROTECTED]]
>
> If you know the size of the number (in position count not
> value) you can use the RPAD(sum(field),count,0) to populate
> the right end of the return value to zero.
> ex. the sum valu
Lisa - I liked your old signature better :).
>>> [EMAIL PROTECTED] 05/31/01 03:17PM >>>
I believe you'll want to rpad your return value.
select rpad(26.5,5,0) from dual
returns
26.50
or format it in SQL*Plus.
HTH
> Lisa Koivu
> Oracle Database Administrator
> 954-935-4117
>
> The informat
I am running multiple Oracle 7.3-8i databases on NT. Is there someone on
this forum who can answer my question:which parameter I need to set up to
increase the file size limit? I have a feeling there may not be one.
I was told by one of the super-senior Oracle people :-) there is an Oracle
(not
Hi Friends
I have 20Gb Table with 3 indexes each 3,6,6Gb size. Recenly we deleted some
2 yrs data from it. So I want to rebuild the Indexes..Iam planning add some
datafiles to it and just rebuild it, so that the new and old indexes fits
easily. Is there any better way???
Thanks
Raghu
Matt,
I know I read that somewhere and yes it could also have referenced a
different OS. If I manage to find the reference I'll happily share it with the
rest of the group, I'm just so in vacation mode right now that I really don't
give a *&^%. But, I will admit that the docs on MetaLink sa
Mark,
I'd like to have a copy of that document too..
- Uma
-Original Message-
Sent: Thursday, May 31, 2001 3:24 PM
To: Multiple recipients of list ORACLE-L
Ditto
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 10:16 AM
To: Multiple recipients of list
No, Oracle 8i will actually merge indexes and perform a pseudo join when
possible without going to either table directly.
"Walking on water and developing software from a specification are easy if
both are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Th
I seem to be confused about the relationship between
tablespace management and allocation methods.
What is the USER allocation_type (as reported by
DBA_TABLESPACES)? I thought this corresponded only to
dictionary-managed tablespaces--I see it associated
with locally-managed tablespaces as well.
Kirti,
Have used both, do not really have a preference.
Dick Goulet
Reply Separator
Author: "Deshpande; Kirti" <[EMAIL PROTECTED]>
Date: 5/31/2001 11:38 AM
Folks,
Just got an e-mail from my Damager that there is a concern about the cost
of TOA
Hi,
It's most likely that you should change your code. If you need furher help,
please attach trace file.
--
Web: htpp://www.unal-bilisim.com
Questions and Answers: http://www.unal-bilisim.com/qa/discus/index.html
Seema Singh wrote:
> Hi
> Some time I am receiving the following informatio
Interesting...Oracle must have changed their minds on this issue. I know we
complained that it seemed crazy for us to pay for OiD when ONAMES is
free...considering Oracle is de-supporting ONAMES and practically forcing
customers to go with OiD (LDAP). I guess they actually used some of the
feedb
I have been using PL/SQL Developer for many years and put alot of
functionality requests for some of the new features in the 3.x and 4.x
product. I would be more than happy to answer any questions you have about
the product.
But to answer your question. The debugger in PL/SQL developer simply r
You can write a little perl script to write over the block. Just open the
datafile, sysseek to (block_number)*(block_size), then
syswrite(chr(0),block_size). Strangely though, the naive approach of
overwriting a block entirely with nulls results in a block which is not
detectable with dbms_repai
We have been using free TOAD for over a year and have gotten from them
somehow an extenstion of the expire license to not expire for the next 5
years. This version of TOAD meets our needs so we see no reason to upgrade
for most of us.
Randy Pace Phone 801 495 9300
9662 S 700 E Fax 801
You need to add new log groups/members of the
appropriate size, and drop the old ones.
-Joe
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, May 31, 2001 3:38 PM
> hi dba's,
>
> In my DB, oracle 816, NT4, the redolog member's size
Did you try EZSQL?
Alex Hillman
-Original Message-
Sent: Thursday, May 31, 2001 3:38 PM
To: Multiple recipients of list ORACLE-L
Folks,
Just got an e-mail from my Damager that there is a concern about the cost
of TOAD licensees and an effort is being made to find a suitable
replacemen
Someone is doing:
dbms_lock.sleep(x)
where 'x' is seconds. It won't be causing any
performance problems - its a 'quiet' wait
hth
connor
--- "Naik, Sandesh S" <[EMAIL PROTECTED]> wrote:
> Hi,
> I need urgent assistance is resolving issues with
> PL/SQL lock timer. My
> query is waiting on thi
unfortunately i am on NT
I can not use BBED because i don't know the password
is there any other way
- Original Message -
To: "'novicedba'" <[EMAIL PROTECTED]>
Sent: Thursday, May 31, 2001 11:40 PM
> I do not recommend this, but since you are bent on doing this:
> (Hope you are on Unix)
offline, drop, create, online in that sequence for the inactive logfiles.
ROR mª¿ªm
>>> [EMAIL PROTECTED] 05/31/01 03:38PM >>>
hi dba's,
In my DB, oracle 816, NT4, the redolog member's size is only 50kb. I'm
having only two groups with a single member each.
I tried with alter database command,
There are un-documented init.ora parameters that can be used to corrupt such
things as the rollback segments and tablespaces. Maybe there is one that
can be used to corrupt a specific block of a datafile as well.
Contact ORacle Support and see if they have any of these. They would be
undocum
talk to your lead duhveloper..they are usally good at that ;-)
Sunil Nookala
Dell Corp
Austin, TX
-Original Message-
Sent: Thursday, May 31, 2001 5:06 PM
To: Multiple recipients of list ORACLE-L
unfortunately i am on NT
I can not use BBED because i don't know the password
is there any
BBED isn't an option unless you can talk Oracle support into taking part in
your experiment - unlikely. (Or perhaps find an appropriate WaReZ site!
(8-o) Any hex editor will do if you aren't particular about exactly what
you change in the block. If you know Oracle block internals you can get a
yup -- that's what I used to try to do
>From: "Thater, William" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Rebuilding indexes
>Date: Thu, 31 May 2001 12:09:37 -0800
>
>On Thu, 31 May 2001,Rachel Carmichael scribble
Yes I know it and sometimes I enforce it using index_join hint.
Regards
Waleed
-Original Message-
Sent: Thursday, May 31, 2001 5:07 PM
To: Multiple recipients of list ORACLE-L
No, Oracle 8i will actually merge indexes and perform a pseudo join when
possible without going to either tab
please mail them to me too
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, June 01, 2001 1:53 AM
> Ken,
>
> (FYI, I used a version of Apache (1.3.12) that came from Apache's web
site,
> not the version that came with Oracle. And my web s
Title: Implementing Stored Procedures
hi
lisa,
we do
have staging area (dba -directory) in production where all
the scripts ...(sql,forms,reports) are kept and with change request forms
they are implemented...
if any
problems with the scripts they willl go to owner of change requester. A
Hi Chris,
Thank you for your detailed response. I have forwarded it to our
Developers. It would be very helpful..
Glad to know that you have contributed to the product's functionality.
Thanks.
- Kirti Deshpande
Verizon Information Services
http://www.superpages.com
> -Original Mes
I personally have 2G files and would never shy away from them. Nothing
worse then having a rather huge database with 6 million files when there
is really no valid excuse for it. I would have happily gone bigger then
2G as well if it were not for the Sun Omniback agent. I will do it on
the HP bo
Raghu,
Index rebuilding is one of those maintenance items that needs doing every
once in a while. Therefore my take is to have a separate tablespace where I can
rebuild the trashed index into, and then rebuild it a second time back into
where it originally came from, but with the correct siz
Has somebody practical experience with the Oracle system sizer of Compaq ?
Does the suggested configuration comes up to expectations ?
Regards,
Rene
--== Sent via Deja.com ==--
http://www.deja.com/
--
Please see the official ORACL
What a hoot! I mean all these wild statements about not needing DBA's
anymore (or sometime in the future). Is Oracle actually getting simpler
with each new release? With tongue firmly planted in cheek, here is the
Oracle 5.1 DBA "OCP" exam. You be the judge...
Q1) How do you cold start an ins
Mark Qualter who handles support for the product is great. Very
responsive to requests reguarding features as well as bugs.
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 5/31/01 6:33 PM
Hi Chris,
Thank you for your detailed response. I have forwarded it to our
De
I also sent an inquiry to Tim Gorman, who wrote the article on the CBO.
He's no novice. He says the fourth join method is
1. nested loops
2. sort merge
3. hash join
and
4. cartesian product !
I kid you not.
By the way, if you're on 8i and haven't already set init parms
OPTIMIZER_
are you a complete idiot?
On 31 May 2001, at 13:34, Bowes, Chris wrote:
> I protest Jared's removal from the list for telling jokes!Henry please
> reconsider! :)
...
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Eric D. Pierce
INET: [EMAIL PROTECTED]
Fat
Don't hold your breath!! BTW: Do you remember the claim of the nuclear power
industry? That by the turn of the century electricity would be so cheap and
plentiful we could waste it at will. Tell that to those folks in California!!!
Dick Goulet
Reply Separator__
> which
> parameter I need to set up to
> increase the file size limit?
There isn't one. On NT the filesize is limited by
the type of filesystem (FAT, FAT32, NTFS, etc...).
I suspect the bug in question is bug 711563, and it's
fixed in the latest 7.3.4.x and 8.0.x patchsets. Yet
another reaso
OK, checked TFM and there are two type of fast refresh snapshots: primary
key (new in 8)
and rowid.
For a rowid snapshot, when the table (EMP) is updated, a row is added to the
snapshot log (MLOG$_EMP) containing mainly the type of action, timestamping
info, and the rowid (MLOG$_EMP.M_ROW$$) of t
Has anyone been successful in using their standby database operating in
read-only mode through a dblink? I can't find any admonishment in the docs.
The dev guys says it will be find for the front-end java code to fail on
any updates.
Ritchie Lau
[EMAIL PROTECTED]
_
---excerpt from trivia site---
On the 60s TV show Green Acres, what was Arnold Ziffel's (the pig)
favorite TV program?
Lost in Space
Combat
Beverly Hillbillies
CBS Evening News with Walter Cronkite
[answer:] CBS Evening News with Walter Cronkite
---
On 31 May 2001, at 1
Some OPS-capable platforms (Tru64? VAX?) already allow "cooked" files for
OPS. Oracle9i will support files for OPS only on certain supported cluster
file systems. Veritos has been explicitly mentioned and Veritos people say
their cluster file system for parallel server will be available by the
Hi Gurus,
Thanks to those who replied. We feel that Unix account is easily hacked, so
we will not implement the method that Rachel mentioned. We will probably
"encrypt" the password in another file. Before exporting, we will decrypt
the password before passing the password to the export script. T
Jared, BBED is available on UNIX, you just have to make
it with the make command.
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed
The bbed command can allow you to soft corrupt a block
and you can use the "dd" command to hard corrupt the
block. The bbed command doe
Take a look at the product Kirti mentioned, PL/SQL Developer, it is a GREAT
product. And $1,000 for 20 licenses, But it is $150 for a single. I
absolutely love it compared to anything out there. I have converted at
least 50 developers to using it.
-Original Message-
To: Multiple rec
Sorry about asking these question , because currently I'm not in my office
so I don't have the document ,Why we need to use Oracles Names /LDAP ??
-Original Message-
Sent: Thursday, May 31, 2001 11:51 PM
To: Multiple recipients of list ORACLE-L
Vikas,
I just implemented Oracle Names
Here's the query and execution plan. Like I said, it took
6-7 hours just to get that without executing. Any insight
appeciated. Remember: I know the workaround (avoid trunc).
I'd just like to know *why* it doesn't work.
Some of the values were dummied up ('' etc.). The actual
query is
Hello gurus,
Could you please advise how to set the block size for various operating systems? eg
HP, aix etc. also this is for oracle 8.
This is urgent, and you can give me any thing, eg url, white paper, etc.
thanks and regards,
raja
Get 250 color business cards for FREE!
http://businessca
Recently upgraded a development database from 8.1.5 to 8.1.7 with the
u080105 script. There is now a certain type of code that errors out with a
ORA-00164 autonomous transaction disallowed within distributed transaction.
But the same code works on 8.1.5, as if a piece of functionality was actual
The most simple analogy is would you prefer to manually
maintain a "host" file on each client or use a single facility
such as a DNS server ot provide the mapping between
hostname & IP_number?
At some point switching from using TNSNAMES.ORA files
on all Oracle servers & client to a single/central
The most simple analogy is would you prefer to manually
maintain a "host" file on each client or use a single facility
such as a DNS server ot provide the mapping between
hostname & IP_number?
At some point switching from using TNSNAMES.ORA files
on all Oracle servers & client to a single/central
Beverly Hillbilies.
At 04:37 PM 5/31/01 -0800, you wrote:
>---excerpt from trivia site---
>
>On the 60s TV show Green Acres, what was Arnold Ziffel's (the pig)
>favorite TV program?
>
> Lost in Space
> Combat
> Beverly Hillbillies
> CBS Evening News with Walter Cronkite
>
>[answer
Title: RE: Tablespace Allocation Type & Extent Management
> -Original Message-
> From: Walter K [mailto:[EMAIL PROTECTED]]
>
> I seem to be confused about the relationship between
> tablespace management and allocation methods.
>
> What is the USER allocation_type (as reported by
>
If you know RCS why not just use a DOS port of it...a quick web search
found
http://www.trumphurst.com/dosrcs.phtml
but maybe not what you're looking for...
Charlie Mengler wrote:
> I'm looking for recommendations for Windows based s/w
> that does the equivalent of SCCS/RCS on Unix. A comm
Hi
I have been sent the following
" I keep coming across references (in the other Oracle 8.0.5 documentation)
to a
document called the "Oracle8 Server SQL Reference", presumably distinct from
the "Oracle8 SQL Reference".
Any idea whether there really is a separate document with that title? If so
pl send me the files.
TIA
--
On Thu, 31 May 2001 12:23:58
Fisher, Julie wrote:
>Ken,
>
>(FYI, I used a version of Apache (1.3.12) that came from Apache's web site,
>not the version that came with Oracle. And my web servers and database
>servers are on different machines. And my web servers
Hi I saw this over on the Sun System admin list and was interested in the
cause of it.
My suspicion is that it has something to do with 2GB files limits
Oracle data base using the imp command on my Solaris 2.6 server
this is the message that I receive
Import: Release 8.1.5.0.0 - Production on T
Sean,
Another option would be:
Get yourself a copy of strings from
http://www.sysinternals.com/misc.htm#Strings (a very useful site for NT
utilities that should have been in NT!).
Do the export (someone else suggested a full export is required)
Then do a
strings -a export_file.dmp | fi
Hi, The suggestion given to go for 18Gigs HDD(SCSI) is a good one. I have seen in H/W
that what u get today u will not get tomorrow. I mean they become obselete. H/W vendor
will say that they nolonger manufacture the same.
Ultra fibre scsi is a technology HDD maufactures use for I/o transfer. Y
Hi,
I have gone thru the manual list. For me Oracle SQL Server ref and Oracle SQL ref
sounds the same. There are 2 more manual SQL*Plus quick ref and SQL*Plus user's guide
and ref.
I have come across these manuals only.
HTH
Venkat
--
On Thu, 31 May 2001 21:05:19
Peter McLarty wrote:
>Hi
>
There are 5 join operations
inner join
equi-join
outer-join
anti-join
self-join
and 3 join methods
neted loop
sort merge join
hash join
sam
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, May 31, 2001 10:55 AM
> 1. Equi-join 2.
Star join or STAR SCHEMA is used for DSS Systems. It actually uses Cartesian
product in its methodology
but still employs Oracle join methods to actually do the joins between the
tables. So there are still 3 join methods.Cartesian (as somebody mentioned
earlier is product rather than a join)
Sam
hi,
the package involved is utl_tcp, i created it under sys. the procedure is
also created without any error under sys.
do i still need to grant execute privilege on it, when sys itself is the
owner.
saurabh
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]
i guess the SGA size is also included in the SZ
> --
> From: Henry Chan[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Friday, June 01, 2001 5:59 AM
> To: LazyDBA.com Discussion
> Subject: how much ram per oracle process?
>
> Environment: Sun 2.
Hi Greg,
I think Tim is right. I've read all the thread and
among all other suggestions cluster join might have been the
best answer. But if I remember correctly it is a kind of N-L
Now going to read the article. Thanks for the link
Regards,
Ed
>
> I also sent an inquiry to Tim Gorman, who
Hi All,
How to import data exported by 8.1.6 into 7.3.4 ?
Thanks
rukmini
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rukmini Devi
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California--
Hi,
AFAIK you can't.
You should run catexp for version 7.3.4 on your 8.1.6 database and than use
7.3.4 binaries to do the export.
jack
"Rukmini Devi"
201 - 291 of 291 matches
Mail list logo