Shut the database     Backup the database     Modify/Include LOG_ARCHIVE_START_TRUE in init.ora file.     Start up the database.

Chiranjeevi Manne

• Mar 30th, 2007

1. it possible to enable archive log mode while creating the database using DBCA.2. By mentioning the required parameters like LOG_ARCHIVE_DEST, LOG_ARCHIVE_FORMAT, LOG_ARCHIVE_START in init.ora file ...

Nitan Jandial

• Dec 28th, 2006

These are points we should consider when we think abt archivelog mode starts automatic Before stutting down the DB, just alter the parameter name "log_archive_start" into "TRUE"Issue the following st...

Answer Question  Select Best Answer

Each  database  user  is  assigned  a Profile that specifies limitations on various system resources available to the user.

gbansal4

 Profile Answers by gbansal4 Questions by gbansal4

• Dec 15th, 2007

A profile is used to restrict the reource uses, password reuses, idle time of a session etc.  We can also attach a password verify function for the database user.  A database user can be assigned a profile.  It is an optional clause.  By default it takes DEFAULT profile.

Chiranjeevi Manne

• Mar 30th, 2007

A profile contains the details about the RESOURCE LIMITS and PASSWORD LIMITS at Oracle level pertaining to a specific user.

Answer Question  Select Best Answer

Statement  auditing  is  the  auditing  of  the  powerful system privileges without regard to specifically named objects.

srinivasanram2004

 Profile Answers by srinivasanram2004 Questions by srinivasanram2004

• Jul 25th, 2008

The Statement auditing is tracking the SQL statements issued by database users. In order to enable or disable auditing on SQL statements, you must have the AUDIT SYSTEM privilege.

Answer Question  Select Best Answer

Object  auditing  is  the  auditing  of accesses to specific schema objects without regard to user.

srinivasanram2004

 Profile Answers by srinivasanram2004 Questions by srinivasanram2004

• Jul 25th, 2008

Object auditing involves the tracking of the specific SQL DML statements issued against objects by database users.

Answer Question  Select Best Answer

Privilege auditing is the auditing of the use of powerful system privileges without regard to specifically named objects.

srinivasanram2004

 Profile Answers by srinivasanram2004 Questions by srinivasanram2004

• Jul 25th, 2008

Privilege auditing involves the tracking of the SQL statements issued by users who have been granted the right to execute that statement through a system privilege. In order to enable or disable audit...

Answer Question  Select Best Answer

meetsanc

 Profile Answers by meetsanc Questions by meetsanc

• Oct 2nd, 2008

For applications dealing with this highly sensitive data like passwords, Oracle provides the DBMS_OBFUSCATION_TOOLKIT PL/SQL package to encrypt and decrypt data. It includes string inputs and raw inpu...

Answer Question  Select Best Answer

What is Oracle Wallet?

imran44

 Profile Answers by imran44 Questions by imran44

• Dec 28th, 2008

Wallet is a Oracle object which keeps the record of Master key for the entire database and all other digital certificates used by the database for encryption purpose. The Walled kept outside the database software and has a different password then DBA system password.

Answer Question  Select Best Answer

What are the features of Database Vault? Can you restrict the sessions with MAC address?

How will you enable database auditing? In How many ways can you implement database auditing?

yossin

 Profile Answers by yossin Questions by yossin

• Oct 15th, 2009

There's another option.There is a product called OraPlayer, that is tracking all actions performed by all the end-users of Oracle Forms. It tracks all the data sent from the forms user to the server and from the server.

johnjohn1976

 Profile Answers by johnjohn1976 Questions by johnjohn1976

• May 25th, 2009

Auditing is a functionality which keep track of all the activity happening to DB There are two type of auditing in Oracle 1, Standard Auditing2. Fine grained Auditing The standard Auditing is again di...

Answer Question  Select Best Answer

 DBA_FREE_SPACEDBA_SEGMENTSDBA_DATA_FILES.

Newton Aseri

• Oct 7th, 2015

DBA_FREE_SPACE
DBA_SEGMENTS
DBA_DATA_FILES..

Answer Question  Select Best Answer

The  Tablespace  to  contain  schema  objects  created without specifying a tablespace name.

kapil

• Nov 1st, 2015

Users need to have a default tablespace, where their objects will be created if they dont explicitly assign a different tablespace during object creation

Chiranjeevi Manne

• Mar 30th, 2007

The default tablespace is the tablepsace in which the user's objects are created. Generally while creating the user, the default tablespace is mentioned. If by any chance the default tablespace is...

Answer Question  Select Best Answer