tag:blogger.com,1999:blog-4096575.post5293414879314269274..comments2024-03-29T03:19:53.607-04:00Comments on The Arup Nanda Blog: Quiz: Mystery of Create Table StatementArup Nandahttp://www.blogger.com/profile/03392706779349258765noreply@blogger.comBlogger13125tag:blogger.com,1999:blog-4096575.post-65710835262782185582020-11-03T08:16:34.290-05:002020-11-03T08:16:34.290-05:00Suggest good information in this message, click he...Suggest good information in this message, click here.<br /><a href="https://5e68b4dadffdc.site123.me/" rel="nofollow"> วิธีการแทงบอล ด้วยสูตรการแทงบอล 1×2 </a>"edok69https://www.blogger.com/profile/08844773385471463764noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-89397530010617400782012-08-27T00:40:56.406-04:002012-08-27T00:40:56.406-04:00Excellent exercise and proof conceptsExcellent exercise and proof conceptsAnonymoushttps://www.blogger.com/profile/10599659663329450266noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-58833516618961847442012-07-29T03:20:45.680-04:002012-07-29T03:20:45.680-04:00very nice sir,
Thanks&Regards
Muhammad Abdul...very nice sir,<br /><br /><br />Thanks&Regards<br />Muhammad Abdul Halim<br />http://halimdba.blogspot.comhalimdbahttps://www.blogger.com/profile/06064045814557676169noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-39704577778624540482012-07-16T07:28:04.580-04:002012-07-16T07:28:04.580-04:00Thank you for influencing so many readers with you...Thank you for influencing so many readers with your great information. Your article has sparked a lot of thought for me. I will share your views and info with my friend and class fellows. Keep it up.<br /><a href="http://www.diskdoctors.com/software/digital-media-recovery/utility.asp" rel="nofollow">digital media recovery</a>Abbeihttps://www.blogger.com/profile/12272969011775207402noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-87199576231623975582012-07-13T06:37:01.884-04:002012-07-13T06:37:01.884-04:00Living it up; living placard statesman n more n mo...Living it up; living placard statesman n more n more.<br /><a href="http://3-credit-bureau-report.net" rel="nofollow">compare them here</a>Anonymoushttps://www.blogger.com/profile/08449113763875751568noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-11442404747361875562012-06-08T13:55:03.332-04:002012-06-08T13:55:03.332-04:00Deferred segment creation was going to be my guess...Deferred segment creation was going to be my guess to but I see lots of others beat me to it :-)Colin 't Harthttps://www.blogger.com/profile/15623835285718803326noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-51026714501626007182012-06-08T13:34:27.727-04:002012-06-08T13:34:27.727-04:00One of the previous comments clearly mentioned tha...One of the previous comments clearly mentioned that it is because of <b>"Deferred Segment Creation"</b> <i>(11g feature)</i>Anonymoushttps://www.blogger.com/profile/14954575071920287518noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-61727362597454170322012-06-08T11:09:33.491-04:002012-06-08T11:09:33.491-04:00Sorry it has nothing to do with dual.
VDESAI2@d...Sorry it has nothing to do with dual.<br /><br /><br /><br />VDESAI2@db > exec vdesai1.manipulate_arup_schema ('create table abc1 as select * from dual');<br />BEGIN vdesai1.manipulate_arup_schema ('create table abc1 as select * from dual'); END;<br /><br />*<br />ERROR at line 1:<br />ORA-01950: no privileges on tablespace 'USERS'<br />ORA-06512: at "VDESAI1.MANIPULATE_ARUP_SCHEMA", line 1<br />ORA-06512: at line 1<br /><br /><br />SYS@db AS SYSDBA> alter user vdesai1 quota unlimited on users;<br /><br />User altered.<br /><br />VDESAI2@db > exec vdesai1.manipulate_arup_schema ('create table abc1 as select * from dual');<br /><br />PL/SQL procedure successfully completed.<br /><br /><br /><br /><br />SYS@db AS SYSDBA> create user vdesai1 identified by ifmc default tablespace users temporary tablespace temp;<br /><br />User created.<br /><br />SYS@db AS SYSDBA> grant connect ,create table to vdesai1;<br /><br />Grant succeeded.<br /><br />VDESAI1@db > create table abc (col1 number);<br /><br />Table created.<br /><br />VDESAI1@db > create table abc1 as select * from dual;<br />create table abc1 as select * from dual<br /> *<br />ERROR at line 1:<br />ORA-01950: no privileges on tablespace 'USERS'<br /><br /><br />VDESAI1@db > select table_name,tablespace_name from user_tables;<br /><br />TABLE_NAME TABLESPACE_NAME<br />------------------------------ ------------------------------<br />ABC USERS<br /><br />--deferred segment creation<br /><br />SYS@db AS SYSDBA> alter user vdesai1 quota unlimited on users;<br /><br />User altered.<br /><br />VDESAI1@db > create table abc1 as select * from dual;<br /><br />Table created.Vishal Desaihttps://www.blogger.com/profile/13334117444053941401noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-55206651653405201272012-06-08T11:04:53.498-04:002012-06-08T11:04:53.498-04:00X.Y>create table abc (col1 number);
Table crea...X.Y>create table abc (col1 number);<br /><br />Table created.<br /><br />X.Y>create table abc1 as select * from dual;<br />create table abc1 as select * from dual<br /> *<br />ERROR at line 1:<br />ORA-01536: space quota exceeded for tablespace 'USERS'<br /><br />It should be Deferred Segment Creation.<br /><br /><br />select * from dba_segments where owner='TEST';<br /><br />no rows selectedTaralhttps://www.blogger.com/profile/00532059230992312309noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-55622381061230012562012-06-08T10:46:29.569-04:002012-06-08T10:46:29.569-04:00Deferred segment creation.
Cheers,
SzymonDeferred segment creation.<br /><br />Cheers,<br />SzymonSzymon Skorupinskinoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-65673363229661807452012-06-08T10:19:57.443-04:002012-06-08T10:19:57.443-04:00@FG - Many apologies. Sloppy copy and paste error....@FG - Many apologies. Sloppy copy and paste error. The error message should have been the same as the actual command, i.e. ... from dual. Anyway, it does not change the underlying question at all.Arup Nandahttps://www.blogger.com/profile/03392706779349258765noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-3101352138467760662012-06-08T10:12:33.236-04:002012-06-08T10:12:33.236-04:00Took me little over 5 mins.
OWNER ...Took me little over 5 mins.<br /><br />OWNER OBJECT_NAME<br />------------------------------ ----------------<br />SYS DUAL<br />PUBLIC DUAL<br /><br />Thanks,<br />VishalVishal Desaihttps://www.blogger.com/profile/13334117444053941401noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-57872519176119600012012-06-08T10:06:46.481-04:002012-06-08T10:06:46.481-04:00Sir, didn't get it.
you executed
arup.manipul...Sir, didn't get it.<br />you executed <br />arup.manipulate_arup_schema ('create table abc1 as select * from dual');<br /><br />and your in your error procedure and parameter is different.<br /><br /><b>BEGIN bus_schema.manipulate_bus_schema ('create table abc as select * from all_objects'); END;</b>FGhttps://www.blogger.com/profile/14366006993501960351noreply@blogger.com