How to create additional tablespaces for an new database?
Answer / Mr.amit Kumar
To create additional tablespaces in a new Oracle database, you can use the CREATE TABLESPACE command. Here's an example: CREATE TABLESPACE ts1 DATAFILE 'datafile1.dbf' SIZE 10M AUTOEXTEND ON NEXT 5M MAXSIZE 50M;
| Is This Answer Correct ? | 0 Yes | 0 No |
find out first highest salary?
10 Answers Verinon Technology Solutions,
Explain oracle data types with examples?
What are the differences between number and binary_float in oracle?
How to count duplicated values in a column in oracle?
How to convert a date to char in oracle? Give one example.
how to unbreak sequence numbers during intereptions
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
How to drop an index?
Which database is better for os platform dependency?
what is the use of system.effective.date variable in oracle?
How to filter out duplications in the returning rows using oracle?
How are the index updates?