Data pump import REMAP_SCHEMA option
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Data pump import REMAP_SCHEMA option

Hybrid View

  1. #1
    Join Date
    Mar 2005
    Posts
    143

    Data pump import REMAP_SCHEMA option

    I have a database 10g. it has theses 2 schemas in it each running its own instance of an application. so the application is called axium. the schema axium is running one instance of the application axium, then there is anouther schema called axiumfp that is running the same application. one group of people log into the application attached to the axium schema and another group of people log into the application attached to the axiumfp. I needed to create a third schema with the same table structure, so I exported the axiumfp then did an import using the REMAP_SCHEMA option to a new schema axiumr. everything was fine until my boss asked me to change the password to the same as one of the other schemas. once I did that you could not attach anything stored in the database as a blob.

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    I assume when you say "export" and "import" you are meaning "expdp" and "impdp".

    Eitherway, was the BLOB issue caused by changing the password of the AXIUMR Oracle account? really?

    What happens if you change the password back?

    What's the actual error stack you are getting?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Mar 2005
    Posts
    143
    Sorry for not being more clear, Yes I mean expdp and impdp, I should have been more specific.
    I thought the issue was caused by changing the passowrd, even though it really didn't make sense to me. However at the time I knew of the problem, I forgot that I changed the pwd, and all I remembered was the new schema, so I dropped it and the problem went away. However I did the impdp lastnight and the users came in this morning at 8 am and were working fine until 8:45 and that is when I changed the pwd, and as soon as I dropped the schema the problem went away. I am now in the process of on another server trying to replicate the issue, by following the same steps as lastnight.

    as far as the errors. I looked at the alert log and saw these errors while the problem was happening:
    Wed Sep 29 08:49:50 2010
    ORA-1691: unable to extend lobsegment AXIUM.SYS_LOB0000076242C00010$$ by 128 in
    tablespace TBLSPC_PMEDIUM
    ORA-1691: unable to extend lobsegment AXIUM.SYS_LOB0000076242C00010$$ by 8192 in
    tablespace TBLSPC_PMEDIUM

    the errrors stop showing up in the alert log after I dropped the user.
    the tablespace TBLSPC_PMEDIUM is set to auto extend and the filesystem that the datafile is on has 121 gigs of free space.

  4. #4
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    the tablespace TBLSPC_PMEDIUM is set to auto extend and the filesystem that the datafile is on has 121 gigs of free space.
    what is the current size of each data file in that TS? Thou you have ample space in the file system each oracle data file has size limitation even in auto extend mode.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  5. #5
    Join Date
    Mar 2005
    Posts
    143
    there are 2 datafiles for the TS. both are physically 32 gigs and the second one oem is showing that it is almost full. Looks like it is time for a third datafile.

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