I need to truncate and load the table same time in the same job everyday.
So in the target I used Oracle enterprise stage with write method as load and
write mode as truncate.
Please let me know whether this works for my requirement,
I tried to do this use the userid of the table owner but I get an error
Access to sys.dba_data_files is required but is not available;
please see your database administrator for select privileges.
Thanks
Oracle table truncate
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 248
- Joined: Fri Jul 30, 2010 9:04 am
Oracle table truncate
Regards,
Kenny
Kenny
Re: Oracle table truncate
That seems pretty clear to me.Access to sys.dba_data_files is required but is not available;
please see your database administrator for select privileges.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
I think the below link will help you:
http://publib.boulder.ibm.com/infocente ... ysadm.html
http://publib.boulder.ibm.com/infocente ... ysadm.html
pandeeswaran
-
- Premium Member
- Posts: 96
- Joined: Fri Aug 20, 2010 8:51 am
Re: Oracle table truncate
You can truncate table before loading in Oracle enterprise stage use "OPEN COMMAND"
begin
execute immediate 'truncate tablename;
begin
execute immediate 'truncate tablename;
Last edited by marpadga18 on Wed Aug 03, 2011 12:27 pm, edited 1 time in total.
-
- Participant
- Posts: 248
- Joined: Fri Jul 30, 2010 9:04 am