Users in oracle

<<Previous   Next>>

Users in oracle - June 11, 2010 at 15:30 PM by Babu Kunwar

Types of users - a local user, an external user, or a global user

In Oracle a user is one who can connect to a database. We can authenticate users in the database with three methods: database authentication, operating system authentication...............
Read Answer

Explain how to create users through Sql Plus.

We need to first login to the data base as: SQLPLUS followed by user_name/password. Then we need to execute the following query:.............
Read Answer

How to delete an Oracle applications user? 

By executing query - DROP user user_name CASCADE;....................
Read Answer

<<Previous   Next>>

Oracle nested table and varrays

A nested table is an unordered set of data elements. These data elements are all of the same datatype. It has a single column whose type is either built in or an object type. It is a table stored within the structure of another table.............

What is SQL Loader? Explain the files used by SQL Loader to load file. i.e Loader control file, Input datafile, Log File, Bad File, Discard file.

SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database. SQL*Loader supports various load formats, selective loading, and multi-table loads......................

Explain different types of segment. Data segment, Index segment, Rollback segment and temporary segment. 

There are four types of segments used in Oracle databases: - data segments - index segments - rollback segments - temporary segments.................. .

Write your comment - Share Knowledge and Experience