INTRODUCTION:
- In this blog, we are going to create the external table
DESIGNATION:
- This is easy to make and easy to insert the data quickly.
- This is much faster than SQL * LOADER.
- In this type of table, we cannot use a DML statement.
- Bulk data can be easily inserted into the table.
OVERALL STEPS:
Step 1: Go to make a directory at the OS level
Step 2: After making the directory
Go to the directory, we have to create a text file and add the necessary values.
Step 3: We have to notify the location of the directory.
Step 4: Go to database, conn sys user
We have to permit for creation of a directory in that user by using the sys
Step 5: Create the directory and mention the location of the OS.
Step 6: Conn sys user,
We have to permit reading and writing to create a directory by using sys.
Step 7: Create the table and give the external format
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter: https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8