What is tablespace in oracle?
how can we create?
how is it manage?
.
.
.
Thnx 2 All in Advnc....:)
Answer Posted / s.s.kumar
The Structure of the table is known as tablespace,
create tablespace
users
datafile
‘/ora01/oracle/oradata/booktst_users_01.dbf’
size
50m;
using alter query we can manage the tablesapace
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to use windows user to connect to the server?
What are the built-in functions used for sending Parameters to forms ?
What is the max number of columns in an oracle table?
What is an oracle tablespace?
How to convert characters to numbers in oracle?
Design database draw er diagram for a certain scenario ?
How to delete a user account in oracle?
What are joins, explain all types of joins?
How to call a sub procedure?
What are the components of logical database structure in oracle database?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What is parameterized cursor in oracle?
How to export your own schema?
In which language oracle has been developed?
How to specify default values in insert statement using oracle?