A deadlock occurs when data was locked simultaneously by two sessions(users) and waiting for data, this can be resolved by rollback statement.

Dead Locks can be resolved by rollback statement.

datafile is the physical storage location of the database.tablespace is logical.for creation of tablespace one or more datafiles needed.we can define the datafile location with the following parameter

db_create_file_dest

Datafiles are physical data location of oracle architecture. Table space contains no.of datafiles.

Exactly View is logical identity.Oracle only stores definition of View in metadata. Using view, we can hide some columns of tables from users, we can hide original table name from user. Using view we can perform complex query in single statement.

Assume that the dba is modifying a tables and the same time developer want to use that database a then dba can provide him the view for that tables.

Code
CREATE VIEW VIEW_NAME(SELECT * FROM A);

Tablespace is a logical content of data It is also called collection of datafiles They are of two types Small tablespace Big tablespace For small tablespace we can create many datafile For big tab...

Table space is the space given to any of data file to get exist into the database provided no two same data files that should exist in any table space.

Logical Structure of Oracle is following.

Tablespace =>Schema => Segments => Extent => Oracle Block. (Remember Oracle block is smallest logical unit).

the logical components of database are tablespaces, segments, extents, datablocks. datablock is the smallest unit of oracle I/0.