Recreate a table with partitions
Posted on 2012-03-12
i have a table X with dependencies to other tables,views and the works ( 325 million rows approx.)
cannot use export import as i have to delete the orig.table.
switch partition is not a option "I THINK?"
what do i do?
I MUST USE read only FILEGROUPS on this table. WHY? because of faster backup and the data will never change. ( create partitions for a quarter ( 4 months). most of the queries runs against this table (cannot create a historic DB) and other issues from the departments.