The privileges to revoke. REVOKE EXECUTE ANY PROCEDURE FROM BARANYILDIZ; REVOKE create ANY table FROM BARANYILDIZ; REVOKE SYSDBA FROM BARANYILDIZ; 900 views last month
Read More »Oracle
Archivelog mod değiştirme
Sysdba kullanıcısı ile sqlplus girişi yapılır. [[email protected] ~]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Sat Jan 12 22:02:41 2019 Copyright (c) 1982, 2014, Oracle. All rights reserved. …
Read More »How To Create A Database Manually | Create a Database Using DBCA Silent Mode in Oracle
Hi, Sometimes you may need to install Oracle database silent or manually instead of GUI( Graphical User Interface ), or sometimes there is no GUI tool like VNC Server, so …
Read More »Bulk and Individual Password Reset For Oracle E-Business ( EBS ) Users
Author : Cihan Gedik Email : [email protected] Linkedin : https://www.linkedin.com/in/cihan-gedik-13b55065/ Group : https://www.linkedin.com/groups/13792740/ Bulk and Individual Password Reset For Oracle E-Business ( EBS ) Users …
Read More »Automatic Diagnostic Repository Command Interpreter (ADRCI)
To start ADRCI in the interactive mode, type adrci at the command line, as shown here: 2,276 views last month
Read More »Determining the Optimal Oracle Undo Retention Period
To determine the optimal value for the UNDO_RETENTION parameter, you must first calculate the actual amount of undo that the database is generating. Once you know approximately how much undo …
Read More »configure disk devices using Oracle ASMLIB
To manage Oracle database’s storage, Oracle recommends The Automatic Storage Management (ASM) to be used regardless of database’s configuration: single-instance Oracle Database or Oracle Real Application Clusters configurations. It is …
Read More »What is the Access Control List ( ACL ) and How to Create and Grant an ACL in Oracle Database
I will explain What is the Access Control List ( ACL ) and How to Create and Grant an ACL in Oracle Database in this article. Let’s review Access Control …
Read More »How to Move, Rename and Relocate Datafiles in Oracle
I will explain How to Move Rename and Relocate Datafiles in Oracle database. 2,256 views last month
Read More »What is the Tablespace in Oracle
I will explain What is the Tablespace in Oracle in this post. 2,929 views last month
Read More »