|
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|