|
-
Even though you have created a seperate tablespace for MAX the object will still be created in it's original tablespace if it exists, in this case it will try and create the object in the TOM tablespace.
This is why increasing the size of the MAX tablespace has no effect.
Look at the error
ORA-01658: unable to create INITIAL extent for segment in tablespace TOM
Remove all quotas on TOM tablespace from user MAX or take the tablespace offline
Regards
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
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
|