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 »Oracle
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,722 views last month, 2 views today
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,721 views last month
Read More »What is the Tablespace in Oracle
I will explain What is the Tablespace in Oracle in this post. 3,545 views last month, 2 views today
Read More »How to Export ( Expdp ) Specific Table Partition in Oracle Datapump
I will explain How to Export and Import Specific Table Partition and Where Condition in Oracle Datapump in this article. Let’s review the Export ( Expdp ) Specific Table Partition …
Read More »