DBA_FREE_SPACEDBA_SEGMENTSDBA_DATA_FILES.
Installing and upgrading the Oracle Server and application tools.Allocating system storage and planning future storage requirements for the database system.Managing primary database structures
Latest Answer: adding to the list* involved in database design * applying patch sets * writing scripts to automate the routine DBA tasks* configuring oracle net such as listeners and tnsnames* data loading and unloading using exp/imp and sqlloader* providing help to ...
DBA - role Contains all database system privileges. SYS user account - The DBA role will be assigned to this account. All of the base tables and views for the database's
Latest Answer: &DBSNMPSupports Oracle SNMP (Simple Network Management Protocol). The Oracle Intelligent Agent requires a database logon for each SID that it manages. By default this account is called "DBSNMP" CheersRavi Prakashhttp://ravidba-oracle.blogspot.com/ ...
SQL * DBA - This allows DBA to monitor and control an ORACLE database. SQL * Loader - It loads data from standard operating system files (Flat files) into ORACLE database
Latest Answer: SQL Plus, SQL Loader, EXP, IMP ...
What are the minimum parameters should exist in the parameter file (init.ora) ?
DB NAME - Must set to a text string of no more than 8 characters and it will be stored inside the datafiles, redo log files and control files and control file
Each server and background process can write an associated trace file. When an internal error is detected by a process or user process, it dumps information
Roles are the easiest way to grant and manage common privileges needed by different groups of database users. Creating roles and assigning provides to roles. Assign each role
Shut the database Backup the database Modify/Include LOG_ARCHIVE_START_TRUE in init.ora file. Start
Latest Answer: 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 before creating the database manually using script.3. ...
By setting the following values in init.ora file. LOG_ARCHIVE_FORMAT = arch %S/s/T/tarc (%S - Log sequence number and is zero left paded, %s - Log sequence
REDUCED GRANTING OF PRIVILEGES - Rather than explicitly granting the same set of privileges to many users a database administrator can grant the privileges
View page << Previous 1 [2] 3 Next >>
Go Top
