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
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
database
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# =
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
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
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
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
DWILLIAMS cc:
@LIFETOUCH.COSubject: RE: Move ALL Data from 1
Database into Another
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
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
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
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
11 matches
Mail list logo