tag:blogger.com,1999:blog-27482298.post2626402359252056422..comments2024-02-25T22:29:18.572+00:00Comments on Andrew's Oracle Blog: Creating Tables in the UNDO Tablespace??Unknownnoreply@blogger.comBlogger5125tag:blogger.com,1999:blog-27482298.post-55776419425063466182016-02-24T13:31:55.623+00:002016-02-24T13:31:55.623+00:00Actually, I had deferred_segment_creation set to T...Actually, I had deferred_segment_creation set to TRUE, but still I wasn't able to create a table in UNDO tbsp.<br />BANNER<br />--------------------------------------------------------------------------------<br />Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production<br />PL/SQL Release 11.2.0.2.0 - Production<br />CORE 11.2.0.2.0 Production<br />TNS for Linux: Version 11.2.0.2.0 - Production<br />NLSRTL Version 11.2.0.2.0 - Production<br /><br />SQL> select value from v$parameter where name='deferred_segment_creation';<br /><br />VALUE<br />------------------<br />TRUE<br /><br />SQL> create table tab1 (col1 number) tablespace undotbs1;<br />create table tab1 (col1 number) tablespace undotbs1<br />*<br />ERROR at line 1:<br />ORA-30022: Cannot create segments in undo tablespace<br /><br /><br />It seems to behave differently in 11.2.0.1 and 11.2.0.2, however I don't have any databases running 11.2.0.1 at the moment, so I can't confirm.Andrzej Nowickihttp://www.andrzejnowicki.plnoreply@blogger.comtag:blogger.com,1999:blog-27482298.post-89906843298293195172016-02-19T20:13:34.355+00:002016-02-19T20:13:34.355+00:00Thank you for your comments. I have now corrected ...Thank you for your comments. I have now corrected the post.Andrew Reidhttps://www.blogger.com/profile/10622696064206411002noreply@blogger.comtag:blogger.com,1999:blog-27482298.post-85242632903972926382016-02-19T09:51:20.654+00:002016-02-19T09:51:20.654+00:00Deferred segment creation... Try inserting a row.Deferred segment creation... Try inserting a row.Dom Brookshttp://orastory.wordpress.comnoreply@blogger.comtag:blogger.com,1999:blog-27482298.post-84589590090049637582016-02-19T08:02:38.322+00:002016-02-19T08:02:38.322+00:00SQL> select banner from v$version;
BANNER
----...SQL> select banner from v$version;<br /><br />BANNER<br />--------------------------------------------------------------------------------<br />Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production<br />PL/SQL Release 11.2.0.2.0 - Production<br />CORE 11.2.0.2.0 Production<br />TNS for Linux: Version 11.2.0.2.0 - Production<br />NLSRTL Version 11.2.0.2.0 - Production<br /><br />SQL> create table tab1 (col1 number) tablespace undotbs1;<br />create table tab1 (col1 number) tablespace undotbs1<br />*<br />ERROR at line 1:<br />ORA-30022: Cannot create segments in undo tablespace<br /><br /><br />SQL> select contents from dba_tablespaces where tablespace_name='UNDOTBS1';<br /><br />CONTENTS<br />---------<br />UNDOAndrzej Nowickihttp://www.andrzejnowicki.plnoreply@blogger.comtag:blogger.com,1999:blog-27482298.post-30679911409457134072016-02-18T21:58:19.992+00:002016-02-18T21:58:19.992+00:00Ohh!!! Interesting.
Thanks for the name check, BT...Ohh!!! Interesting.<br /><br />Thanks for the name check, BTW. I'll try and check this out in a couple of weeks when life calms down. end-of-a-book hell.Martin Widlakehttps://mwidlake.wordpress.com/noreply@blogger.com