Interested to Buy Any Domain ? << Click Here >> for more details...
What is TABLE SPACE?
- 4 Answers
- 11986 Views
- ABB, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / dileep
A Table space is a logical group of data files in a data
base. a typical data base consists at least one table space,
and usually two or more. In a database a table space plays a
role similar to that of a folder on the hard drive of a
computer.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / m.m
Tablespace:
A database storage unit that groups related logical
structures together.
logical structures:
Logical structures of an Oracle database include table
spaces, schema objects, data blocks, extents, and segments.
Because the physical and logical structures are separate,
the physical storage of data can be managed without
affecting the access to logical storage structures.
physical structures:
Physical database structures of an Oracle database include
data files, redo log files, and control files.
data block:
Smallest logical unit of data storage in an Oracle
database. Also called logical blocks, Oracle blocks, or
pages. One data block corresponds to a specific number of
bytes of physical database space on disk.( a common block
size is 8k)
extent:
Second level of logical database storage. An extent is a
specific number of contiguous data blocks allocated for
storing a specific type of information.
segment:
Third level of logical database storage. A segment is a set
of extents, each of which has been allocated for a specific
data structure, and all of which are stored in the same
tablespace.
Datafile:
A physical operating system file on disk that was created
by Oracle and contains data structures such as tables and
indexes. A datafile can only belong to one database.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / mohan
Database is logically divided into three tablespaces. once
creates the database then automatically create tablespace
is also called SYSTEM tablepace.tablespace contain dta
dictionary of all data.
| Is This Answer Correct ? | 0 Yes | 1 No |
what is self join and what is the requirement of self join? : Sql dba
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
Explain locks? : Transact sql
Types of indexes. What is the default key created when a primary key is created in a table ?
How to get the procedure's, function's name from a package if it is wrapped(both spec & body).
What is sql and explain its components?
What are % type and % rowtype?
How to connect a sql*plus session to an oracle server?
How do I upgrade sql?
What is the main difference between sql and pl/sql?
What are variables in pl sql?
Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
