A database link is a named object that describes a "path" from one database to another.
Latest Answer: There are different categories of database link:1) private link2) public link
Other category based on access is:1) connected user2) fixed user3) current user
With the combination of all the above 5 points we can create database link with
different ...
Private Database Link, Public Database Link & Network Database Link.
Private database link is created on behalf of a specific user. A private database link can be used only when the owner of the link specifies a global object name in a SQL statement or in the definition
Public database link is created for the special user group PUBLIC. A public database link can be used when any user in the associated database specifies a global object name in a SQL statement or object
Latest Answer: A database link is a pointer that defines a one-way communication path from an Oracle Database server to another database server. The link pointer is actually defined as an entry in a data dictionary table. To access the link, you must be connected to ...
Network database link is created and managed by a network domain service. A network database link can be used when any user of any database in the network specifies a global object name in a SQL statement
ORACLE database's data is stored in data blocks. One data block corresponds to a specific number of bytes of physical database space on disk.
Latest Answer: Oracle Data Blocks is logical storage unit of Oracle and One Oracle Data Blocks containts multiple of Operating system Blocks. Data blocks contains contigous of Bytes. ...
A data block size is specified for each ORACLE database when the database is created. A database users and allocated free database space in ORACLE datablocks. Block size is specified in INIT.ORA file and
Latest Answer: stansard block size, which is set with parameter DB_BLOCK_SIZE cannot be changed after creating database. We can set non standard parameter size later with parameter DB_nk_BLOCK_SIZE and it can be changed.NOTE: Standard block size cnannot be equal ...
In Circumstances, all of the data for a row in a table may not be able to fit in the same data block. When this occurs , the data for the row is stored in a chain of data block (one or more) reserved for
Latest Answer: If a row is too large to fit into a single database block row chaining happens. For example, if you use a 4KB blocksize for your database, and you need to insert a row of 8KB into it, Oracle will use 3 blocks and store the row in pieces. Some conditions ...
An Extent is a specific number of contiguous data blocks, obtained in a single allocation, and used to store a specific type of information.
Latest Answer: An extent is a logical unit of database storage space allocation made up of a number of contiguous data blocks. One or more extents in turn make up a segment. When the existing space in a segment is completely used, Oracle allocates a new extent for the ...
A segment is a set of extents allocated for a certain logical structure.
Latest Answer: A segment is a set of extents that contains all the data for a specific logical storage structure within a tablespace. For example, for each table, Oracle allocates one or more extents to form that table's data segment; for each index, Oracle allocates ...
View page << Previous 3 4 5 6 [7] 8 Next >>
Go Top
