Last post Dec 05, 2010 06:18 PM by seetoronto
Jan 27, 2010 04:19 PM|thakkarbhav|LINK
I have to automate one database process in .Net web applicaiton which uses Oracle 11g Database as Backend.
I need to know two things:
(1) How to check space on Oracle database server? I need space on server and not in the Database itself. My process creates few tables so I want to make sure that we have sufficient space before the process starts.
(2) Also I need to create script to backup Indexes and Triggers on the table so that I can recreate them after data transfer process is completed. Any idea how to create script form c# code?
Many thanks for your time.
Oracle 11g free space index trigger create script
Mar 26, 2010 11:49 AM|thakkarbhav|LINK
I resolved this using Impersonate setting. This allows specified user to access remote database server to find out freespace on the server. This was needed as we have automated task which takes almost a day to completed and we wanted to make sure that we
have sufficient space on the server before the task begins.
Dec 05, 2010 06:18 PM|seetoronto|LINK
do you know any hosting service which provides Oracle as backend instead of Ms Sql server.
Kindly revert back