DBA_COLL_TYPES DBA_COL_COMMENTS DBA_COL_PRIVS DBA_CONSTRAINTS DBA_CONS_COLUMNS DBA_CONTEXT DBA_ERRORS DBA_INDEXES DBA_IND_COLUMNS DBA_IND_EXPRESSIONS DBA_IND_PARTITIONS DBA_IND_SUBPARTITIONS DBA_OB_DATABASES DBA_OB_LS_LOCATIONS DBA_OB_MAJOR_COMPACTION DBA_OB_TABLEGROUP_TABLES DBA_OB_TABLEGROUP...
namely keeping your organization’s databases and applications running up to par. The DBA has to be the resident DBMS expert (whether that is DB2, Oracle or SQL Server, or most likely a combination of those). He or she has to be able to solve thorny...
The user running the DataPump job has the DATAPUMP_IMP_FULL_DATABASE or IMP_FULL_DATABASE role which should be enough to run the DBMS_DST procedure. But, ORA-1031 occurs in DataPump when DBA role is not granted to the import user. Cause Sign In...
(‘USERENV’,’ISDBA’)=’TRUE’ THEN DBMS_SESSION.SET_ROLE‘READWRITE’) ; ELSE DBMS_SESSION.SET_ROLE(‘READONLY’) ; END; / Which three statements correctly...
A Data Guard configuration consists of one database that functions in a primary role and one or more databases that function in a standby role. Typically, the role of each database does not change. However, if the primary database becomes unavailable or if hardware or software maintenance ...
On the new source database (SalesDB-B), stop the capture process using the STOP_CAPTURE procedure in the DBMS_CAPTURE_ADM package. SQL> select capture_name,status from dba_capture; CAPTURE_NAME STATUS --- --- STRMADMIN_CAPTURE ENABLED SQL> exec dbms_capture_adm.stop_capture (capture_name...
Only grant them when necessary to roles and trusted users of the database. You can find a complete list of system privileges and their descriptions in Oracle Database SQL Language Reference. To find the system privileges that have been granted to a user, you can query the DBA_SYS_PRIVS dat...
DBA_AUDIT_TRAIL DBA_COLL_TYPES DBA_COL_COMMENTS DBA_COL_PRIVS DBA_CONSTRAINTS DBA_CONS_COLUMNS DBA_CONTEXT DBA_ERRORS DBA_INDEXES DBA_IND_COLUMNS DBA_IND_EXPRESSIONS DBA_IND_PARTITIONS DBA_IND_SUBPARTITIONS DBA_OB_DATABASES DBA_OB_LS_LOCATIONS ...