Hi Every One , What is the table Space in Oracle Database ?
waiting for answere and thankyou
Answers were Sorted based on User's Feedback
Answer / shilpa
A tablespace is a logical storage unit within an Oracle
database. It is logical because a tablespace is not visible
in the file system of the machine on which the database
resides. A tablespace, in turn, consists of at least one
datafile which, in turn, are physically located in the file
system of the server. Btw, a datafile belongs to exactly one
tablespace.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / ramprasad
HI
Table spaces are to store oracle data.
bye
sun_ramprasad@yahoo.com
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / thirupathi.l
table space nothing but adate base can be logically stored
into asmaller logical area space known as table space
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / guneetinder singh
Table space in a database is the logical space used by the
oracle when oracle wants to do some common work by grouping
many other subgroup, then the common group is called tablespace.
generally tablespace is of 6MB.
Out of which 2MB is system reserved and 4MB is available to
user.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / rakesh
table space is collection of data files means database is
logically divided inro tablespaces and physically into data
files
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / tanoy guhasarkar
A tablespace is a logical storage unit within an Oracle
database. It is logical because a tablespace is not visible
in the file system of the machine on which the database
resides. A tablespace, in turn, consists of at least one
datafile which, in turn, are physically located in the file
system of the server. Btw, a datafile belongs to exactly one
tablespace.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nirmala.s
In oracle,
if u use DATE, u can get the date,
if u use TIME, u can get time
if use time space , u can get both date and time even
in milli sec ALSO(HH:MM:SS:MS)
Is This Answer Correct ? | 0 Yes | 3 No |
What is format trigger?
select * from emp what happened internally when we write this query in the sql prompt?
why pl sql doesn't support retrieving multiple records
What is difference between a formal and an actual parameter?
difference between oracle8i and oracle9i
I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it
What is BBED in Oracle?
What are data pump export and import modes?
How can we create the complete backup of data in the oracle.
0 Answers IPEC, Satyam, SunTec,
How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?
What are the logical operations?
Describe the different type of Integrity Constraints supported by ORACLE ?