How do you set up tablespaces during an oracle installation?
Answer / Deep Agnihotri
During Oracle installation, you can create tablespaces using SQL commands such as 'create tablespace' and 'alter tablespace'. You can also use a script to automate the process. The script might include creating datafiles, specifying the tablespace properties like size, growth, and location, and setting up temporary tablespaces.
| Is This Answer Correct ? | 0 Yes | 0 No |
Tell me about standby database? What should we watch out for?
What is oracle log switch?
You see multiple extents in the temporary tablespace. Is this a problem?
What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?
Who is a database user?
What are the roles and responsibilities of oracle dba?
What does a senior database administrator do?
You see a wait on lms process in statspack, what does that mean?
What are the steps involved in instance recovery in oracle?
What are functions of dba?
What is a database instance?
What os user should be used for the first part of an oracle installation (on unix)?