Posts

Load the data into Oracle database using SQL Loader

Image
 Load the data into Oracle database using SQL Loader- SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database. It supports various load formats, selective loading, and multi-table loads. OR  SQL*Loader is a command line utility, provided by Oracle to load data from external files into Oracle database. Note-  We can only insert the data into target tables. In SQL*Loader, during the process of loading data from external file, It needs two input files and generates three output files.  Input files- Data File Control File  Output files- Log File Bad File Discard File In details- 1. Data File: It is a flat file/external file/source file, which we need to load into database. 2. Control file: Control file defines the structure of a flat file/external file/source file. How the data is           formatted in data file, information about target table to load the data etc. Process- SQL Loader reads...
Post a Comment
Read more

Unlock password for "internal" user in Oracle APEX

  Unlock "internal" user password in Oracle APEX -> Go to location where apex is installed- C:\apex_20.1_en\apex> -> connect with sqlplus then / as sysdba -> To unlock the account instead of completely resetting the password, you can use the below PL/SQL block: begin     wwv_flow_security.g_security_group_id := <APEX_WORKSPACE_ID>;     wwv_flow_fnd_user_api.UNLOCK_ACCOUNT('<APEX_ACCOUNT_NAME>');     commit; end; / In detail- -> Go to the location where apex is installed- C:\apex_20.1_en\apex> -> Open command prompt (Run as administrator) and connect as sysdba Example as below- C:\apex_20.1_en\apex>sqlplus You will get- SQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 24 17:37:56 2020 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle.  All rights reserved. Enter user-name: / as sysdba Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 -> Get the worksp...
1 comment
Read more

Reset password for "internal" user in Oracle APEX

Reset password for "internal" user in Oracle APEX: Steps to follow- -> Go to the location where apex is installed like below- C:\apex_20.1_en\apex> -> Open command prompt (Run as administrator) and connect with sqlplus  and login as sysdba Example as below- C:\apex_20.1_en\apex>sqlplus you will get- SQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 24 17:37:56 2020 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle.  All rights reserved. Now enter username- Enter user-name: / as sysdba Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 -> Run command-   @apxchpwd.sql Example to reset password as below-  SQL> @apxchpwd.sql ...set_appun.sql ================================================================================ This script can be used to change the password of an Application Express instance administrator. If the user does not yet exist, a user record will be created. ==================...
1 comment
Read more