On Wed, Jul 03, 2002 at 09:02:34AM -0400, Ray Stell wrote: > > I want to move a db to a different machine with a different disk > layout. If I create the db and tablespaces on the new machine, can I > use a dmp file created by exp full=y to move all the data? The dmp > tries to create the tablespaces under the old structure, and these > commands will fail, because the names are already there. Are there > other things in the dmp that will shoot me in the foot? --
Pressing on, I was able to hit a few toes. I get the following errors. I neglected to mention I am moving from 8.1.7.2 to 8.1.7.4. IMP-00017: following statement failed with ORACLE error 4042: "BEGIN " "SYS.DBMS_UTILITY.EXEC_DDL_STATEMENT('GRANT EXECUTE ON DBMS_DEFER_QUERY TO D" "BA');" "COMMIT; END;" IMP-00003: ORACLE error 4042 encountered ORA-04042: procedure, function, package, or package body does not exist ORA-06512: at "SYS.DBMS_SYS_SQL", line 824 ORA-06512: at "SYS.DBMS_SQL", line 32 ORA-06512: at "SYS.DBMS_UTILITY", line 409 ORA-06512: at line 2 All of the subsequent calls to DBMS_UTILITY get the same errors. So, what did I miss? Where is this utility supposed to be created? =============================================================== Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).