How to create additional tablespaces for an new database?



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

Post New Answer

More Oracle General Interview Questions

find out first highest salary?

10 Answers   Verinon Technology Solutions,


Explain oracle data types with examples?

1 Answers  


What are the differences between number and binary_float in oracle?

1 Answers  


How to count duplicated values in a column in oracle?

1 Answers  


How to convert a date to char in oracle? Give one example.

1 Answers  


how to unbreak sequence numbers during intereptions

1 Answers   Ion Exchange,


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.

1 Answers   IBM,


How to drop an index?

1 Answers  


Which database is better for os platform dependency?

1 Answers  


what is the use of system.effective.date variable in oracle?

1 Answers  


How to filter out duplications in the returning rows using oracle?

1 Answers  


How are the index updates?

1 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1803)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)