[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 403
  • Last Modified:

How can I do this?

I want to create a temporary table called TempSKUs using a comma delimited text file named
"TestData" stored in C:\Test folder.

I want to use the temporary table linked to tables from a database on a server.

How can this be done?

1 Solution
Two main ways:

1. Import the data into a table via SQL* Loader - http://www.orafaq.com/wiki/SQL*Loader_FAQ

2. Create an External Table which points to the file - http://www.orafaq.com/node/848
kosenrufuAuthor Commented:
Can I create a temp table using a .csv file?
Yes, either of those methods I linked to can achieve it. The first one moves the data into the database, the second one allows the database to read the data which stays in the file.
slightwv (䄆 Netminder) Commented:
They really don't create a 'temp' table.  The only thing in Oracle that resembles a temp table is a Global Temporary Table and even those are persistent database objects (The stay around).

I also want to point out that with external tables, the text file has to be on the database server.  Using sql*loader the file can be anywhere.
You can go with external table to load access you file from oracle DB for more details please check this below link:


And to get a grip on external table please check the links provided before by MrNed and also this link too:


As this has shown a good example.


Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now