<div>
No comment has been added lately, so it's time to clean up this TA.<br />
I will leave the following recommendation for this question in the Cleanup topic area:<br />
<br />
Accept: ypwitkow {<a href="http:#8216223" rel="ugc">http:#8216223</a>}<br />
<br />
Please leave any comments here within the next four days.<br />
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!<br />
<br />
walterecook<br />
EE Cleanup Volunteer
</div>


No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

Accept: ypwitkow {http:#8216223 [http:#8216223]}

Please leave any comments here within the next four days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

walterecook
EE Cleanup Volunteer

<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
We need to backup one oracle table every week before it is dropped. I wrote one scripts as:<br />
<br />
CREATE TABLE a1backup<br />
AS SELECT * FROM al;<br />
<br />
I need to run this as cron every week. My question is how to specify the name of backup table(table name + date)? Like albackup03212003, a1backup31042003, ….<br />
<br />
Thanks<br />
Terry
</div>
</div>


Hi All,

We need to backup one oracle table every week before it is dropped. I wrote one scripts as:

CREATE TABLE a1backup
AS SELECT * FROM al;

I need to run this as cron every week. My question is how to specify the name of backup table(table name + date)? Like albackup03212003, a1backup31042003, ….

Thanks
Terry

Table Naming Conversion

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.