[table-space] Forum Topics

Hey every body , Just need a bit of help with a problem understanding something. When I install Oralce onto a computer what are the default tablespaces and their role in the whole thing. What information is held in the DATA_DICTIONARY for examining tablespaces and their status? Is my second …

Hi can somebody tell me how to delete a table space? Some days ago I deleted a table because I thought I didn't need it anymore. When I tried to recreate it I got this error: ERROR 1813(HY000): Tablespace for table 'test','employees' exists.PLEADE DISCARD the table space before import; I …

Hi All, I have a table space in which i have eight columns. The first column is Index which i kept as Auto_Increment starting from 1 so that i can see the number of rows of data anytime. The problem is, for example i have one row of data and …

Hi All, I am having a tablespace named Incident which has eight columns . The first column is index which i kept as auto increment. The columns are 1.index(auto_increment) 2.ticket_no (String) 3.date(String) 4.description (String) 5.priority (int) 6.state (String) 7.follow_up (String) 8.status (String) Now i tried to insert test row in …

hi to all, i want to create user on student table IN ORACLE.... CREATE USER john IDENTIFIED BY out_standing DEFAULT TABLESPACE users QUOTA UNLIMITED ON users DEFAULT TABLESPACE temp QUOTA UNLIMITED ON system; but, oracle shows following error like...."insufficient priviveleges on password... please give some suggestion for creating user in …

how can i alter the INITIAL and NEXT value of a table. I tried something and ended up with the following code. [code]ALTER TABLE TABLENAME ADD ( PRIMARY KEY (ORDER_ID) USING INDEX TABLESPACE TALLYDATA PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED …