Interested to Buy Any Domain ? << Click Here >> for more details...
Hi Every One , What is the table Space in Oracle Database ?
waiting for answere and thankyou
- 8 Answers
- 11477 Views
- I also Faced
- E-Mail Answers
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 |
HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT
5 Answers College School Exams Tests, DELL,
write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"
How to assign a tablespace to a users in oracle?
how to find count rows in table without count function?
What are the factors that affect OPTIMIZER in choosing an Optimization approach ?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
diff between DELETE and TRUNCATE?.
14 Answers HCL, Yalamanchili Software,
What is max rowid in oracle?
Difference between cartesian join and cross join?
What do you mean by group by clause?
Hi Can any one tell me what are the API's used in requisition import.
What exactly do quotation marks around the table name do?
Oracle General 
