Home » SQL & PL/SQL » SQL & PL/SQL » Can i dynamically create and drop the external tables in the procedure?
Can i dynamically create and drop the external tables in the procedure? [message #222210] Fri, 02 March 2007 05:22 Go to next message
lokesh.sql
Messages: 9
Registered: November 2006
Location: Pune
Junior Member
Hi All ,

I have the doubt like can I create and drop the external table dynamically using execute immediate in the procedure. Can any one suggest? Please help me out.


Thanks in advance
Regards
Lokesh
Re: Can i dynamically create and drop the external tables in the procedure? [message #222212 is a reply to message #222210] Fri, 02 March 2007 05:46 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Yes you can, but should you?.

Any dynamic creation/dropping of objects is almost certainly a bad idea unless you're doing a one shot data load (and then just do it in a SQL script.

Previous Topic: SQL Query
Next Topic: Storage doubt
Goto Forum:
  


Current Time: Sat Dec 10 18:46:39 CST 2016

Total time taken to generate the page: 0.06560 seconds