What is the column and value that you would be splitting on? Are you working within a single database or will the new tables be in a separate database?

Depending on how many tables you are looking out you could just do multiple

Select

column_list

INTO

new_table_name

from

order_details

where

partition_column = [value]

To start and then convert them into

INSERT INTO new_table_name

Select

column_list

From

order_details

Where

partition_column = [value]

'

for the ongoing process.

There are other options and you could automate it a bit.