Skip to content

Updateable External Tables

February 2, 2009

I work in IT field for the past so many years and if I do not blog about some technical matter then I am not doing justice to my blog. I will therefore post something on Oracle since I have been working with Oracle database for some time now

Now people who work with Oracle database will know that Oracle 9i introduced something called as External Tables which allow us to read data directly from flat file instead of using SQL Loader utility. You may need to read the link thoroughly to understand what is an external table? and how it works?

Now Oracle imposes some restriction on external tables like Index cannot be created on an external table or Data Manipulation (DML) cannot be done using an SQL on external tables.

I recently read about doing DML on external tables by a workaround, ofcourse there are some caveats on doing this. Kindly read about it here and make sure you read about caveat as well.

No comments yet

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: