On Wed, 13 Nov 2002, [EMAIL PROTECTED] wrote:
> Are you sure about the "one round trip" thing.
Turns out you are right about not doing a single round-trip per row.
My information was either outdated or apocryphal:
SQL> select value from v$sesstat ss, v$statname sn where sid = 31 and
ss.statistic
Hi Jeremiah
> I don't like any of the suggestions so far, because they take more
> time than necessary. DB links do ONE ROUND TRIP for every row
> fetched! That is not efficient. Export is a nightmare of potential
> failures. I think you can devise the best solution by just copying the
> databa
and attached these to new 8i
database.
Thanks & Regards,
Vipin Jain
-Original Message-
From: VIVEK_SHARMA [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, November 14, 2002 12:41 PM
To: LazyDBA.com Discussion
Subject:RE: Move ALL Data from 1 Database into Another
Forgive
Forgive the previous incomplete post.
Hi Ankur
QS. After Migrating the Oracle 7 Database to 8i , Using Transportable Tablespaces
Can one Simply use DETACH the Application Tablespaces (OTHER Than SYSTEM) & Attach them
to the Newly Created 8i Database ?
Thanks Indeed
Hi Jeremiah
Some of the Data
Some of the Data Dictionary Objects are Corrupted in the Live Production Oracle 7
Database
-Original Message-
Sent: Thursday, November 14, 2002 5:14 AM
To: Multiple recipients of list ORACLE-L
I don't like any of the suggestions so far, because they take more
time than necessary. DB
I don't like any of the suggestions so far, because they take more
time than necessary. DB links do ONE ROUND TRIP for every row
fetched! That is not efficient. Export is a nightmare of potential
failures. I think you can devise the best solution by just copying the
database files.
Try this ide
> What about foreign keys, functions, procedures, synonyms, roles, grants
and
> triggers (if any)? I've used the db link and it's faster than imp/exp but
> it doesn't do anything for other database objects. Also, if you do have
> foreign keys then a certain amount of pre-planning is necessary to
What about foreign keys, functions, procedures, synonyms, roles, grants and
triggers (if any)? I've used the db link and it's faster than imp/exp but
it doesn't do anything for other database objects. Also, if you do have
foreign keys then a certain amount of pre-planning is necessary to move
da
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 would be
Vivek - If it is critical, I would test each alternative on a small amount
of data. I have had pretty good results from the data link. Depending on the
number of CPUs, you can run multiple imports or multiple data links
simultaneously. Also watch your disk storage conflicts. For example, you
wouldn
Qs What would be the FASTEST way to Load ALL Data from a Source Database
Existing in 7.3.4 into an Empty Target Database in 8.1.7.4 ?
NOTE - Creation Fresh (NEW) Database is a Must because Some of the
Data Dictionary Objects have got Corrupted & the Standard Migration of
the Same Oracle 7 Data
11 matches
Mail list logo