problem while importing [message #123374] |
Mon, 13 June 2005 00:50 |
kusuma_web
Messages: 1 Registered: June 2005
|
Junior Member |
|
|
HI all,
i am recent graduate and want to join as a DBA.i am getting problem while importing the table from one user to another.i.e space quota exceeded for tablespace.Though i have enough space i am getting this problem.can any one help me.
Thanks in advance...
|
|
|
Re: problem while importing [message #123418 is a reply to message #123374] |
Mon, 13 June 2005 06:54 |
nabeelkhan
Messages: 73 Registered: May 2005 Location: Kuwait
|
Member |
|
|
Please post error number, DB version and OS info.
Are you getting :
ORA-30027: Undo quota violation - failed to get string (bytes)
or
ORA-01536: space quota exceeded for tablespace 'string'
If 30027 then increase undo quota, or wait until other transactions to commit before proceeding and if 01536 then Either drop unnecessary objects in the tablespace to reclaim space or have a privileged user increase the quota on this tablespace for the segment owner. Else Seems like quota exceeding of the user you are tryin to import into, increase the quota for the user and try again.
How do u know the space is enough for import?
|
|
|