--- DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx> wrote: > Srinivas > My theory as a DBA is to perform tasks in a > manner that is least likely > to cause bad consequences. Is there any way > export/import would work for > you? I have a much warmer feeling about using that > to relocate my important > data. Just create a new 9i database, check it out, > make sure it is ready to > go, practice the export/import, then perform the > cutover. Much less to go > wrong. > > Dennis Williams Dennis, 8.1.7.4.x is not without issues regarding exp. I'd make quite sure that all patchsets have been applied to the 8174 db regarding exp, so that he does not end up with an import log full of ORA-00907s. Paul __________________________________ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/ ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------