dbTalk Databases Forums  

Moving File after using it in external table load

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss Moving File after using it in external table load in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Randall
 
Posts: n/a

Default Moving File after using it in external table load - 10-29-2008 , 02:23 PM







Using Oracle 9.2.0.8 on Windows XP.

I am loading a file into an external table then dropping the table and
trying to move the file used to create the external table to another
folder. A lock is maintained on the file even after droppping the
table. Is there some method of releasing the lock so I can move the
file ... or am I missing something.

Thanks in advance,

Randall

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.