|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
February 21st, 2005, 01:54 PM
|
|||
|
|||
|
creating table with storage/table space clause,
i am suppose to create a table on my non-default tablespace and the name of it is "temp"! (i used select * from user_users to find that out) but i get an error!
 Code:
create Table courses (
course_no NUMBER CONSTRAINT pk_course_no Primary Key,
course_name Varchar2(30),
c_level char(1) check (c_level in('1','2','3','M')),
department Varchar2(25))
(tablespace temp,//
STORAGE (initial 5|2 Next integer)
);
gives me an error on line 6 which has // at the end of it, error i get is "missing or invalid optioon"
|
|
#2
February 22nd, 2005, 04:56 PM
|
|||
|
|||
|
Code:
create Table courses (
course_no NUMBER CONSTRAINT pk_course_no Primary Key,
course_name Varchar2(30),
c_level char(1) check (c_level in('1','2','3','M')),
department Varchar2(25))
STORAGE (initial 5|2 Next integer)
tablespace temp;
|
|
#3
February 27th, 2005, 10:38 AM
|
|||
|
|||
|
Code:
create Table courses (
course_no NUMBER CONSTRAINT pk_course_no Primary Key,
course_name Varchar2(30),
c_level char(1) constraint chk_c_level check (c_level in ('1','2','3','M')),//
department Varchar2(25))
tablespace temp
STORAGE (initial 5k next 2k pctincrease 0);
is the right syntax, or the one that "works" but it gives me an error in the // saying: Code:
ERROR at line 6: ORA-02195: Attempt to create PERMANENT object in a TEMPORARY tablespace
|
|
#4
February 28th, 2005, 07:39 AM
|
||||
|
||||
|
As I said in the other post
 The user has the default temporary tablespace set to "temp" and you are trying to create a table in it.
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > creating table with storage/table space clause, |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
