| athul |
Posted: Jul 02, 2009 10:10:03 AM |
Total Post: 3
Joined: Jul, 2009
|
SQL> create table test (id number) tablespace athul;
Table created.
SQL> create table test as (select * from hr.employees);
Table created.
works... but
SQL> create table test as select * from hr.employees tablespace athul;
not working... anyone tell the solution pls...
|
|
|
chai |
| Posted: Jul 02, 2009 03:00:35 PM | |
|
Total Post: 319
Joined: Jul, 2008
|
Check whether user, who is creating table is having permission/quotas to use atul tablespace space or not.
|
|
|
|
|
athul |
| Posted: Jul 03, 2009 10:03:47 AM | |
|
Total Post: 3
Joined: Jul, 2009
|
I got the solution......
SQL> create table test tablespace athul as select * from hr.employees ;
|
|
|
|
|
anil |
| Posted: Jul 06, 2009 10:50:21 AM | |
|
Total Post: 41
Joined: Dec, 2007
|
SQL> create table test as (select * from hr.employees) tablespace athul;
this will work
|
|
|
|
|
athul |
| Posted: Jul 06, 2009 11:40:49 AM | |
|
Total Post: 3
Joined: Jul, 2009
|
It will not work Anil.. Without trying don't reply and that too a wrong answer. Its wrong.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |