Hi,
We are migrating from oracle
7.3.4.3 to oracle 9.2.0.4
without changing clientcode which
is built with oci 7
for oracle 7 db. Code gives this error while printing
all bind variables with values such that
I can only conclude all
variables are bound.
Binding doesn't produce an
-Oorspronkelijk
bericht-
Van: Jeroen
van Sluisdam [mailto:[EMAIL PROTECTED]]
Verzonden: donderdag 27 november 2003 19:09
Aan: Multiple recipients of list
ORACLE-L
Onderwerp: RE: migration sequence
oci problem
We could narrow it down to the value of the sequence exceeding
16777216 (2 to the power of 24
but I'm desperate for any advice because I don't
have any developers
left with oci-knowledge
Tnx,
Jeroen
-Oorspronkelijk
bericht-
Van: Jeroen van Sluisdam
Verzonden: Wednesday, November 26,
2003 16:40
Aan: '[EMAIL PROTECTED]'
Onderwerp: migration sequence oci
problem
Hi,
We're
-knowledge
Tnx,
Jeroen
-Oorspronkelijk bericht-
Van: Jeroen van Sluisdam
Verzonden: Wednesday, November 26, 2003 16:40
Aan: '[EMAIL PROTECTED]'
Onderwerp: migration sequence oci problem
Hi,
We're testing an oracle 9.2.0.4 database with an
oracle 7 client
Hi,
We're testing an oracle
9.2.0.4 database with an oracle 7 client.
This is a C++ client, using OCI to go to oracle.
We see strange behaviour when using a sequence which worked
nicely before. The sequence is not incremented when issueing
select
res_id.nextval from dual
When
Does anybody know whether or not Oracle will support and upgrade of an 8i database to 10? Thanks
American Express made the following
annotations on 11/21/2003 07:28:27 AM
--
Yes.
On 11/21/2003 09:29:31 AM, Tracy Rahmlow wrote:
Does anybody know whether or not Oracle will support and upgrade of an 8i
database to 10? Thanks
American Express made the following
annotations on 11/21/2003 07:28:27 AM
Mladen,
Direct 8i(as in 8.1.7.4) to 10 or do you HAVE to go through 9.x first?
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Friday, November 21, 2003 9:39 AM
To: Multiple recipients of list ORACLE-L
Yes.
On 11/21/2003 09:29:31 AM, Tracy
From what I read, and learned from the private sources, it's going to be
a direct migration. Of course, I don't have 10g , so I can't tell for sure.
This tight lid on the software is, in my humble opinion, ridiculous.
My next answer to an oracle sales person will be that I have to keep the
tight
Oracle Database 10g provides a fairly easy upgrade path for users of older Oracle
versions. The following versions can directly be upgraded to Oracle Database 10 g:
Oracle Database 8.0.6
Oracle Database 8.1.7
Oracle Database 9.0.1
Oracle Database 9.2
If your database version is not in the
According to the presentation by Dave Foster of Oracle at the last
UNYOUG meeting, there will be a direct upgrade from 8.1.7 and 9.2.
Also, the new dbassistant has an undo feature, to rollback the upgrade.
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
Life is like a sewer, what you get out of
:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 3:29 PM
To: Multiple recipients of list ORACLE-L
So - this is a stupid question:
We cannot use Oracle's migration utility to go from 32-bit 8.1.7 to 64-bit 9i?
- Hmmm, create database , export, import.
-Original Message-
Sent: Thursday
recipients of list ORACLE-L [EMAIL PROTECTED]
|
| cc:
|
| Subject: RE: Migration utility
catproc.
Tom Mercadante
Oracle Certified Professional
-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 3:29 PM
To: Multiple recipients of list ORACLE-L
So - this is a stupid question:
We cannot use Oracle's migration utility to go from 32-bit 8.1.7 to 64-bit
Hi
Any good books available to convert applications from RBO to CBO.
References to Oracle 9i.
Regards
Suhen
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Suhen Pather (S)
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
the datafiles over and run a migration utility to convert the 32 bit
db to 64 bit. I personally have never heard of such utility. Could you
please share your experiences. How reliable is this utility and where to
find the docs on this
Thanks,
Murali.
--
Please see the official ORACLE-L FAQ
Suhen:
John K has a nice paper (IOUG-A?) at his website. Google for his name or
'RBM CBO Migration minefields'
Regards,
Gopal
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: K Gopalakrishnan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
Suhen,
Any good books available to convert applications from RBO to CBO.
References to Oracle 9i.
I am not aware of any book, but there is a limited number of articles/papers
(most well-known is Tim Gorman's 'Search for intelligent life in the CBO' at
http://www.evdbt.com) that can point you in
Also, Sun-Tszu, The Art of War is the useful book to read
before attempting migration.
On 11/13/2003 10:44:39 AM, K Gopalakrishnan wrote:
Suhen:
John K has a nice paper (IOUG-A?) at his website. Google for his name or
'RBM CBO Migration minefields'
Regards,
Gopal
--
Please see
Especially where he says that the King shouldn't meddle with the
general's doings.
SF
Mladen Gogala wrote:
Also, Sun-Tszu, The Art of War is the useful book to read
before attempting migration.
On 11/13/2003 10:44:39 AM, K Gopalakrishnan wrote:
Suhen:
John K has a nice paper (IOUG
) we
copy the datafiles over and run a migration utility to convert the 32 bit
db to 64 bit. I personally have never heard of such utility. Could you
please share your experiences. How reliable is this utility and where to
find the docs on this
Thanks,
Murali.
--
Please see the official
So - this is a stupid question:
We cannot use Oracle's migration utility to go from 32-bit 8.1.7 to 64-bit 9i?
- Hmmm, create database , export, import.
-Original Message-
Sent: Thursday, November 13, 2003 2:49 PM
To: Multiple recipients of list ORACLE-L
It's actually an sql script
Oracle's migration utility to go from 32-bit 8.1.7 to 64-bit 9i?
- Hmmm, create database , export, import.
-Original Message-
Sent: Thursday, November 13, 2003 2:49 PM
To: Multiple recipients of list ORACLE-L
It's actually an sql script that's located in the $ORACLEHOME/rdbms/admin
someone please help me?
Assumption situation - Platform migration of Oracle DW on Oracle DB (data
volume 3.5 TB) from HP-UX to IBM-AIX
1.. DB migration; it is correct to use Export/Import technique/method in
the above assumption?
2.. Witch is the time frame in a worst case for this (how
]
Sent: Monday, November 10, 2003 12:24 AM
Hi List,
Could someone please help me?
Assumption situation - Platform migration of
Oracle DW on Oracle DB (data
volume 3.5 TB) from HP-UX to IBM-AIX
1.. DB migration; it is correct to use
Export/Import technique/method in
the above assumption
recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 12:24 AM
Hi List,
Could someone please help me?
Assumption situation - Platform migration of
Oracle DW on Oracle DB (data
volume 3.5 TB) from HP-UX to IBM-AIX
1.. DB migration; it is correct to use
Export
- Platform migration of
Oracle DW on Oracle DB (data
volume 3.5 TB) from HP-UX to IBM-AIX
1.. DB migration; it is correct to use
Export/Import technique/method in
the above assumption?
2.. Witch is the time frame in a worst case
for this (how many hours,
days or weeks!!)?
3
List,
Could someone please help me?
Assumption situation - Platform migration of
Oracle DW on Oracle DB (data
volume 3.5 TB) from HP-UX to IBM-AIX
1.. DB migration; it is correct to use
Export/Import technique/method in
the above assumption?
2.. Witch is the time frame
platforms.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 12:24 AM
Hi List,
Could someone please help me?
Assumption situation - Platform migration of
Oracle DW on Oracle DB (data
volume 3.5 TB) from HP
Hi List,
Could someone please help me?
Assumption situation - Platform migration of Oracle DW on Oracle DB (data
volume 3.5 TB) from HP-UX to IBM-AIX
1.. DB migration; it is correct to use Export/Import technique/method in
the above assumption?
2.. Witch is the time frame in a worst case
A. Teles wrote:
Hi List,
Could someone please help me?
Assumption situation - Platform migration of Oracle DW on Oracle DB (data
volume 3.5 TB) from HP-UX to IBM-AIX
1.. DB migration; it is correct to use Export/Import technique/method in
the above assumption?
No. Would take
Hi List,
Could someone please help me?
Assumption situation - Platform migration of Oracle DW on Oracle DB (data
volume 3.5 TB) from HP-UX to IBM-AIX
1.. DB migration; it is correct to use Export/Import technique/method in
the above assumption?
Use exp/imp only for transporting
Thanks for all the help. I was under a bit of time pressure and
it was a small database, so a just created a new database on the
8.1.7.4 (AIX 5.2) system and imported my tables.
Something was seriously wrong with the upgrade script, because the
java migration step ran all night and still had
Environment:
AIX 5.2
Oracle 8.1.7.4
I copied a database from an 8.1.7.0 environment and am going
through the procedure to migrate it to 8.1.7.4. My Oracle home has
already been patched.
When I get to step 10 in the procedure where it says:
SQL create or replace java system
/
sqlplus hangs.
SQLPlus probably doesn't hangit take a long time to create or replace
JAVA on some systems.
-Original Message-
Sent: Thursday, October 16, 2003 3:14 PM
To: Multiple recipients of list ORACLE-L
Environment:
AIX 5.2
Oracle 8.1.7.4
I copied a database from an 8.1.7.0 environment
recipients of list
ORACLE-L [EMAIL PROTECTED]
c.com cc:
Sent by: Subject: 8.1.7 to 8.1.7.4 database
migration - step 10 hangs
Peter,
First, are you sure it is hanging? It does take quite awhile to finish.
Secondly, did you up the Jave_Shared_Pool param to a decent value (I think
the migration doc says 4Meg, but increase it to 8 and try it again).
and finally, if you are not using Java in the database, it really
Title: Migration 9201 to 9203 doc needed
Does anyone have the subject Metalink note? Oracle's gateway problems are preventing access to ML.
Thanx,
Alan Martin
Defense Logistics Info Service
Title: Migration 9201 to 9203 doc needed
Unless Im really missing something,
going from 9.2.0.1 to 9.2.0.3 is just a patch install, and the README.html
included in the patch should tell you what you need to do.
--Walt Weaver
Bozeman, Montana
-Original Message-
From
Title: Message
Your
right, sorry. My brain is fried today.
Thanx,
Alan
-Original Message-From: Weaver, Walt
[mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003
5:20 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: Migration 9201 to 9203 doc needed
I am looking for some expert suggestions for the migration of 300GB database to
different hardware. Currently database is 816 OPS on AIX 4.1 nodes. Database is 32bit
and performance on this system is really slow. Export for 2GB table takes 2 hours. All
the data is on EMC symmetric.
We
If you cannot recover the database, you *** CAN *** take a cold backup
and open it elsewhere, on a 5.2 box, for example. You only have to make sure
that you loaded the right post_wait extensions. I advise you to use the ones
from 9.2. Boot the machine in 32 bit mode. No migration is necessary
:
[EMAIL PROTECTED]Subject: Migration Suggestion.
m
I use the A) strategy for medium BD's with good
performance behavior, for the fragmentation issue a
good guide is the document:
How to stop fragmentation and start living.
you can find it in metalink..
regards,
Gabriel
--- AK [EMAIL PROTECTED] wrote:
At present we have one tablespace
ak,
I have located my indexes in different tablespaces according to size
of the index and catagory. Small indexes are in one tablespace with 4K
extents and medium in 1M extents with the large in 20M extends. The
tables that are partitioned also have the indexes partitioned. Some
tables span
recipients of list ORACLE-L
Sent: Tuesday, July 22, 2003 7:54
PM
Subject: LMT Migration
At present we have one tablespace containign all
indexes . Some indexes arebig in size some are small . Currently
tablespace is dict managed. This tablespace currently highly fragmented
.
Now I
AK
The link for How to Stop Defragmenting and Start Living is here:
http://metalink.oracle.com/cgi-bin/cr/getfile_cr.cgi?239049
http://metalink.oracle.com/cgi-bin/cr/getfile_cr.cgi?239049
This is a classic paper and I consider it essential to carefully study this
paper before you embark on your
After Migrating a production Database from 8.1.7.4 to 9.2.0.3.0 (64 Bit) on Solaris 8
following NON-Documented parameters were set by Oracle Corp
_shared_pool_reserved_min_alloc=16384
This was done to take care of the ORA-4031 errors. This caused shared pool erros to
STOP Occuring
though at
Looks like a whole set of bugs we haven't come across YET
-Original Message-
Sent: 20 June 2003 10:14
To: Multiple recipients of list ORACLE-L
After Migrating a production Database from 8.1.7.4 to 9.2.0.3.0 (64 Bit) on Solaris 8
following NON-Documented parameters were set by Oracle
*** Comments by BECKER, BILL Fri Jun 20, 2003 -- 08:09:59 AM
We upgraded to 64-bit 9.2.0.3.0 on Solaris 9 a few weeks ago,
and are currently experiencing ORA-01733 virtual column not allowed
here errors - bug 2884797. This is a star transformation bug,
and you are likely to hit it if you
I don't think the cursor sharing will help. We've been going 'round and
'round with the shared pool fragmentation problem and the 4031 errors.
Flushing the shared pool might or might not work; sometimes it cleans things
up; sometimes it doesn't do anything (as far as I can tell). About all you
Hi
Gurus
I am looking for a
tool/method resource to migrate over 100 reports written in Oracle character
based reporting tool to Developer 6i. Appreciate any help link or any method
that could speed up this process. There is link on Oracle Metalink that refers
to forms migration, I am
Check
out www.kumaran.com
Dick GouletSenior Oracle DBAOracle Certified 8i DBA
-Original Message-From: Baswannappa, Shiva
[mailto:[EMAIL PROTECTED]Sent: Wednesday, June 18, 2003 2:20
PMTo: Multiple recipients of list ORACLE-LSubject:
Tool/Method for migration of Oracle character
Hi:
Thanks to everyone who responded to my message on Cross Platform
Migration... I will update the list if we come to any conclusions not
consilient with the findings given on the list..
Thanks Regards,
Sashi
Sashidhar Kondareddy
Project Manager
IT Solutions Inc, a SEI CMM Level 5
: Saturday, June 07, 2003 7:29 AM
To: Multiple recipients of list ORACLE-L
..
Hi all:
We are considering migration of an Oracle eBusiness Suite 11.5.8 from
HP-UX 11.0 to Solaris9.
I'd like to know if anyone has done this and how daunting the task is.
Are there any 3rd Party tools which can help out
You may want to review an article, Cross Platform Migration of a Large Production
Database, in
the latest issue(2nd Qtr 2003) of SELECT journal (by IOUG).
The author details the procedure he followed to migrtate a 300GB production database
from HP-UX to
IBM AIX.
- Kirti
--- Goulet, Dick
Aah !Hint, hint that some certain RDBMS vendor will offer cross-platform
compatibility of database files soon.
Hemant
At 04:14 AM 07-06-03 -0800, you wrote:
Sashidar:
In THEORY HP datafiles and Sun data files are compaible. That is you
can just move the HP data files to the Sun server and
in parallel/unrecoverable mode. The
goal was to get both the source and target hosts as close to 100%
utilization as possible.
This was Oracle 8.0.5, migrating Compaq Tru64 (DEC OSF to HP-UX 11
64-bit.
The migration took 6 hours. It shouldn't have even taken that long,
but we were clumsy in a few
Message-
Sent: Saturday, June 07, 2003 7:29 AM
To: Multiple recipients of list ORACLE-L
..
Hi all:
We are considering migration of an Oracle eBusiness Suite 11.5.8 from
HP-UX 11.0 to Solaris9.
I'd like to know if anyone has done this and how daunting the task is.
Are there any 3rd Party tools
that was on a
much earlier version of Oracle (6.0.x).
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Saturday, June 07, 2003 7:29 AM
To: Multiple recipients of list ORACLE-L
..
Hi all:
We are considering migration of an Oracle eBusiness
Suite 11.5.8
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
06/09/2003 07:59 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over
dblink or ..
You may want to review
Hi all:
We are considering migration of an Oracle eBusiness Suite 11.5.8 from
HP-UX 11.0 to Solaris9.
I'd like to know if anyone has done this and how daunting the task is.
Are there any 3rd Party tools which can help out?
Coming to the conventional approaches:
1. What do you think of Export
Sashidar:
In THEORY HP datafiles and Sun data files are compaible. That is you
can just move the HP data files to the Sun server and recreate the data
files. Both data files are in same endianness and they are cross
platform compatible.
There is no tool to convert a datafile from one OS format
K
I'm looking to move a large database from HP/Compaq/DEC Alpha to Sun. Any
possibility the datafiles might be compatible?
Sashidar
This was discussed quite a bit on this list 5/14, the subject was
quickest method. The consensus seemed to be that:
1. SQL*Loader in direct path mode is the
Why don't you try it? Create a small database on Alpha, rcp it to
HP and see what happens.
On 2003.06.07 09:39 DENNIS WILLIAMS wrote:
K
I'm looking to move a large database from HP/Compaq/DEC Alpha to Sun. Any
possibility the datafiles might be compatible?
Sashidar
This was discussed
Hi gurus,
I have just migrated from Oracle 8.1.6 to Oracle 8.1.7 (Enterprise Edition on
Windows 2000) but when I try to query my partitoned tabless I get the error
ORA-00604 'error occured at recursive SQL level 1'
ORA -00904 'Invalid column name'
I have run the scripts U0801060.sql (which calls
Hi
We had a different problem with our upgrade but the same error message -
there is a patch available from Oracle that is supposed to help(did n't for
us though)
Regards,
N.
-Original Message-
[EMAIL PROTECTED]
Sent: 01 April 2003 09:04
To: Multiple recipients of list ORACLE-L
Hi
Hi All -
I am trying to automate our code migration from Test to Prod and here is the
pseudo code :
1. connect to Test
2. create a database link to point to production
3. connect thru the database link to production
4. run the migration sql code
5. drop the database link
Here are my questions
An ora 1452 error says there are duplicate keys, hence you can't create a
unique key. If it is a known, death be unto me if I am wrong, 100% fact
that the unique key was valid in the original data, the first question I
would ask is: Was this an import that is being run with commit=y ignore=y,
Hi Friends,
Iam migrating data from 7.3.2 to 8.1.7.4 with exp/imp, when Iam importing
into 8.1.7.4 Iam getting silly errors like
IMP-00017: following statement failed with ORACLE error 1452:
CREATE UNIQUE INDEX TTIITM009001$IDX1 ON TTIITM009001
I checked in metalink and other sites for help,
]
cc:
Subject:migration
Hi Friends,
Iam migrating data from 7.3.2 to 8.1.7.4 with exp/imp, when Iam importing
into 8.1.7.4 Iam getting silly errors like
IMP-00017: following statement failed with ORACLE error 1452:
CREATE UNIQUE INDEX TTIITM009001$IDX1 ON TTIITM009001
Do you have a Sybase Open Client CD ? The odbc drivers are usually on there.
From my Sybase years I recall that the ODBC drivers were sourced from
Merant, now DataDirect technologies, might be worth looking there.
Personally I'd go for the bcp out/SQL*Loader in scenario.
Ade
-Original
Hello Listers,
Anyone used this tool? What was your experience like?
I am planning on using it to move about 20GB of data from a
Sybase 11.x database to Oracle 8i (Rel 3). This is a one time
activity. Flat file route (using Sybase 'bcp') is the
alternate solution. I would like see if we
Thanks for your response.
This morning I was informed that there is a Sybase Open Client CD that I can use (if
they could find it :) We do have a few Sybase products, so we have support, licenses
etc
We will be exploring both known avenues to get the data into Oracle database. Sybase
bcp
Kirti,
I am no Sybase expert, but I am staring at a Sybase to SQL Server migration,
and I installed the Sybase client tools on my machine and it gave me Sybase
Adaptive Server ODBC driver Release 3.50.00.10. Unfortunately I can't tell
you if my version is newer or yours is (50 is bigger than 11
Kirti,
I am no Sybase expert, but I am staring at a Sybase to SQL Server migration,
and I installed the Sybase client tools on my machine and it gave me Sybase
Adaptive Server ODBC driver Release 3.50.00.10. Unfortunately I can't tell
you if my version is newer or yours is (50 is bigger than 11
Hello Listers,
Anyone used this tool? What was your experience like?
I am planning on using it to move about 20GB of data from a Sybase 11.x database to
Oracle 8i (Rel 3). This is a one time activity. Flat file route (using Sybase 'bcp')
is the alternate solution. I would like see if we could
Hi Listers,
We are planning to migrate one of our SQL Server database to ORACLE 9i.
Please point me to the checklist and required documents. Any help in
this regard very much appreciated.
regards
Banarasi Babu T
OCP, DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Look into Oracle Migration Workbench (on technet, it's free).
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, February 04, 2003 4:18 AM
Hi Listers,
We are planning to migrate one of our SQL
a
migration tool, but I haven't used it. Usually I follow a procedure such as:
1. Create objects in Oracle.
2. Dump data from SQL Server to a flat file.
3. Load the data with SQL*Loader.
4. Verify the data, application.
5. Prepare for production cut-over.
6. Truncate Oracle tables.
7. Dump data from SQL
Read-up:
http://otn.oracle.com/documentation/oracle9i.html
http://otn.oracle.com/pls/db92/db92.docindex?remark=homepage
--
Lyndon Tiu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Lyndon Tiu
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
. But
something like ERwin could help you out with that.
DTS is great for simple data loads, not sure how complicated your migration
is, but its something to look into.
Good luck!
-Original Message-
Sent: Tuesday, February 04, 2003 9:40 AM
To: Multiple recipients of list ORACLE-L
Babu
in Oracle? I think Oracle provides a
migration tool, but I haven't used it. Usually I follow a procedure such as:
1. Create objects in Oracle.
2. Dump data from SQL Server to a flat file.
3. Load the data with SQL*Loader.
4. Verify the data, application.
5. Prepare for production cut-over.
6. Truncate
Evans
Hi Stephen Evans,
Thank you for your earlier response to the migration issue.Here i want to eloborate this specific requirement
so that you can advise us more.The requirement goes like this:
We have a Sybase database and one non-proprietory DB in our old system and these two database
Hi,
Thank you for your responses.
What kind of strategies should be followed while migrating data from Sybase to Oracle
and non-propriatory databases to Oracle so that the down time is as low as possible.
The Sybase database size is 2TB and other DB's total make up to 400GB
any
recipients of list ORACLE-L
Hi Everyone,
We need to migrate data from a Sybase DB to Oracle 9i DB and both the data
models defer a lot.
Is there any tool available for this kind of migration. Can we do this
migration with out any tool.
If yes please let me know like how should we go about
of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:data migration strategies
Hi,
Thank you for your responses.
What kind of strategies should be followed while migrating data from Sybase to Oracle
and non-propriatory databases to Oracle so that the down time is as low as possible
Hi Everyone,
We need to migrate data from a Sybase DB to Oracle 9i DB and both the data models
defer a lot.
Is there any tool available for this kind of migration. Can we do this migration with
out any tool.
If yes please let me know like how should we go about this migration
vijay,
oracle has a free product call 'Oracle Migration Workbench' that i understand is very good at transferring objects data from sybase to oracle.
however, i do believe that schemas (ie table structures) need to be the same - or at least will be created the same in the oracle database. you
Hi all,
Can anyone give me estimate time required for migrating a DB on 8.1.7
to 9.0.2.
Size of the DB is 10GB.
RAM is 1 GB.
It is a dual CPU system on windows NT.
Thanx
Kranti Pushkarna
This message is for the designated recipient only and may contain
privileged, proprietary, or otherwise
again, thanks. I also have shelves full of books, but I can't read them
cover to cover (and don't want to, I like having a life that isn't
completely Oracle).
Not even yours Jared, not even yours. I think the only ones I can say
for certainty that I've read cover to cover are a)the ones I've
when using parallel DML.
Are you talking about a single process using parallel DML? I guess I could
imagine that even in a case such as a single parallel update setting a
column to a constant. Even though the parallelism would have broken things
up by block ranges, migration could occur
This is a single process executing PDML -
As you guessed, the problem arises where
an update causes a migration into the top
block on the free list - every PX slave is updating
a different range, but they might all migrate
into the same free block.
Except --
a) Oracle handles this differently
An interesting philosophical question -
How do you find out something that you
ought to know, when you don't know
that it exists to be found out about, and
don't know that you need to know it ?
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon a new one-day tutorial:
Cost
I read the list of course. Or post a question on how to do something.
I have a quirky sort of memory that jogs me with I seem to recall
having read something sort of along those lines when I have a problem.
And I've found that the answer either has already been posted or I post
the question and
Migration
Listers,
8.1.7.4 64 Bit Solaris
Does row migration utilize DB File Sequential Reads on the
table?
Off the
top of my head I would expect so, but I've never tested
something
like that
before.
--
Please see the official ORACLE-L FAQ: http
it.
Regards,
Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Rachel
Carmichael
Sent: Friday, December 27, 2002 10:29 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Row Migration
don't
Woe is me ! Another person who hasn't
got a copy of my book; published Dec 2000.
P.227 - 230: Inline Updatable Views
A brief discussion of the method and
note about requirements.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon a new one-day tutorial:
Cost Based
I managed to miss the point that you were
concerned with work done and time lost on
the update rather than the subsequent
retrieval. Concerns about scatter are pretty
irrelevant at this point.
To address the issues of row migration (and
strictly ignoring row chaining), I would start
oh I have your book, I just didn't remember where I had seen the code!
blame too little caffeine, blame being woken at 3AM, blame a senior
moment :)
--- Jonathan Lewis [EMAIL PROTECTED] wrote:
Woe is me ! Another person who hasn't
got a copy of my book; published Dec 2000.
P.227 - 230:
1 - 100 of 300 matches
Mail list logo
