Full exp 8.1.7 and Full imp 9i - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: Full exp 8.1.7 and Full imp 9i

  1. #11
    Join Date
    Feb 2005
    Location
    Luxembourg
    Posts
    28
    Hi,

    ok, jmodic, i tried it with your proposal. thanks for the exampe! (with an ordanary user with the profile "dba" and "exp_full_database").

    I looked in the file=exp_8_1_7.dmp in the beginning of the export (the end file is about 4.3GB).

    I saw the "create user" statements in there! But they didn't appear in the log=error.log .

    Does anybody have an explanation for this behaviour?

    If i create the users prior to the import, the import is with error, but at least, the import creates a few of the tables.

    I'm guessing if i would also create also the roles and profiles bevor i'm doing the import, it would work (have to try it tomorrow).

    I have NO idea why i have to do this manually!

    thanks in advance for any type of proposal...
    Last edited by buck; 10-26-2005 at 12:05 PM.

  2. #12
    Join Date
    May 2005
    Location
    AZ, USA
    Posts
    131
    Observation...

    http://download-west.oracle.com/docs...mp.htm#1005557

    (But I don't advocate it myself.)

    Migration... !

    http://download-west.oracle.com/docs...de.htm#1008864
    (Shouldn't they change that to the 'old' 9i release?)

  3. #13
    Join Date
    Feb 2005
    Location
    Luxembourg
    Posts
    28
    i'm trying to create Users, Roles, Profiles and Tablespace upfront manually right now. Because i couldn't find what's going wrong here (the DBUA is still the backup method ) with the full exp/imp.

    I am gonna post the result.

  4. #14
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    run dbua, you will done in an hour, save yourself lots of hassle with exp /imp

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width