Home » RDBMS Server » Backup & Recovery » problem while importing
problem while importing [message #123374] Mon, 13 June 2005 00:50 Go to next message
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 Go to previous message
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?

Previous Topic: what type of backup is best
Next Topic: Importing dump taken from higher version to lower version
Goto Forum:
  


Current Time: Thu Mar 28 18:01:12 CDT 2024