Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Move file using Oracle package UTL_FILE

Status
Not open for further replies.
Palmero

Palmero

Technical User
Mar 31, 2001
53
FR
Hi all,

From a flat file, I'm loading an oracle V8i table using Oracle UTL_FILE package. If the process is ok, I want to move the source file to a backup directory with the following changed name : name_of_my_file||sysdate.

Do you have an idea on how to process if possible?

Thanks in advance for your answer.

Palmero.
 
Sort by date Sort by votes
are you using unix. If so run the procedure thro shellscript. and at the end it use the unix mv command.I'm using it that way.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Chopstik
  • Locked
  • Question
How to identify a package based on a code snippet 1
Replies
1
Views
341
Andrzejek
Andrzejek
TheLazyPig
  • Locked
  • Question
Oracle Data Validation 1
Replies
4
Views
149
TheLazyPig
TheLazyPig
KeyserSoze
  • Locked
  • Question
TOAD for Oracle - Icons
Replies
1
Views
183
Andrzejek
Andrzejek
Server Guy
  • Locked
  • Question
Solaris 10 update 9 iso file
Replies
0
Views
120
Server Guy
Server Guy
Olutee360
  • Locked
  • Question
Group by using values in a range 1
Replies
4
Views
131
Olutee360
Olutee360

Part and Inventory Search

Sponsor

Back
Top