Oracle 10g file handling

We will copy the files from one disk group to another diskgroup. Identify the file. Take the file offline and copy it using rman utility. Now file has been copied, we can update the dictionary with the new ASM Diskgroup location. Finally recover and take the file online.

Delete the old file from ASM directory. Posted by Sandeep Redkar at PM. No comments:. Newer Post Older Post Home. Subscribe to: Post Comments Atom. Even better, a binary file can be copied from a directory on a remote database server to a directory on the local database server.

Finally, a binary file can be copied from a directory on the local database server to a directory on a remote database server. This package makes it easy to back up binary files between directories or servers. The first example sends a simple e-mail without any attachments. The second example sends another e-mail message, but this time includes an attachment in the format of a RAW datatype. This article has delved into several new features, but I encourage you to explore even more deeply on your own - you will be pleasantly surprised at the breadth of the enhancements!

While there is no substitute for direct experience, reading the manual is not a bad idea, either. I have drawn upon the following Oracle 10g documentation for the deeper technical details of this article:. Search Search. Featured Database Articles Oracle. If exists, it would replace with a new file. If you need preserve the file, open with 'A' append mode.

However, there are other options in Oracle 11g. Which version of Oracle are you in? I will also give you an inside secret that will help you to learn Oracle standard library functions quick.

They provide nice documentation with enough comments on what is done in the procedure call What is the error you get?

Improve this answer. Guru Guru 2, 6 6 gold badges 31 31 silver badges 47 47 bronze badges. This only retrieves the list of directory, I wanna know the files in each directory too Though I should have ask this in a different thread I just want to make sure if the file is created.

I tried writing but I still got the same error Thank you very much for your time. Hema Hema 1. Sign up or log in Sign up using Google. Exit Search Field. Select Language. Mark Foster September 25, Director. Facebook Twitter LinkedIn Email. Given we now know the approach we can begin to build the example Create a new "BPM Application" Add a File Adapter to the Composite In the composite view add a "File Adapter" if you don't see the "Components" window click on the "Window" tab and select it Here we specify the CSV file as it will be after conversion from Excel Now we return to the file adapter wizard