Home » RDBMS Server » Performance Tuning » create table
create table [message #65227] Mon, 21 June 2004 18:33 Go to next message
ECI
Messages: 10
Registered: May 2004
Junior Member
how to create a table every day with a variable name of test_date.

I need to create a table every day every 3am and named that as test_date.

date is variable.

How to do that... thank you
Re: create table [message #65228 is a reply to message #65227] Mon, 21 June 2004 21:09 Go to previous messageGo to next message
Ajendra
Messages: 165
Registered: February 2004
Senior Member
Have you tried with DBMS_JOB package and for creating the table dynamically EXECUTE IMMEDIATE
Re: create table [message #65229 is a reply to message #65228] Mon, 21 June 2004 22:25 Go to previous messageGo to next message
ECI
Messages: 10
Registered: May 2004
Junior Member
Is DBMS_JOB included in oracle9i?
where i can get this package?
thank you
Re: create table [message #65230 is a reply to message #65229] Tue, 22 June 2004 21:02 Go to previous message
Ajendra
Messages: 165
Registered: February 2004
Senior Member
Yes its included in 9i. Here is a sample example. You can get plenty of example on this in net.

CREATE OR REPLACE procedure daip_clear_event_log_job
is
v_job number:=90;
dt1 date:=to_date('06-jan-2004 10:00:00','dd-mon-yyyy hh:mi:ss');
begin Dbms_Job.iSubmit ( job => v_job, what => 'YOUR_PROC_NAME;', next_date => dt1, interval => 'sysdate + 1');
Dbms_Job.Run ( v_job );
Dbms_Output.Put_Line ( 'Submitted as job # ' || to_char ( v_job ) );
end;
/
Previous Topic: diff between physical reads and physical reads direct
Next Topic: Index maintenance
Goto Forum:
  


Current Time: Wed Feb 21 12:06:17 CST 2024