Re: How to move partition files

[Adrian Chapela Cordeiro]

I am thinking about, but I want to store old data in partitions.

I have two classes of hard disks, SAS high speed disks and SATA low speed disks but with high capacity.

I will use SATA to store old data. Recent data is the most used data on my environment (and normally in all environment) and I need high speed for it.

Another option could be do a select on a partition of the table and do a select on real table insert on the "datawarehouse table", but It is more slow than moving a file from one disk to another disk. Is it possible to do a select only on one partition ?

Something like:

select * from table#namepartition

If this is possible, a select insert for me could be a workaround because the piece of the table is about 400 MB size.

Another option to have a table to store old data ?

Thank you!