Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Backup table Job - every day

qwe12654Jun 3 2010 — edited Jun 3 2010
Hi,

I want to create a copy of a table and save it as a new table with the date as part of the table name every night, please advice how to create a job...

eg

Table_ABC

I want copies as follows:

TABLE_ABC_JUN_01_2010
TABLE_ABC_JUN_02_2010
TABLE_ABC_JUN_03_2010


Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 1 2010
Added on Jun 3 2010
#job, #table
3 comments
952 views