If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Copying a 22Gig partition from Production to Development

I need to copy a 22G partition from our production to development database.

What is the best way to do this with minimum time spent on resources. I am under the impression that transportable tablespaces feature needs the datafiles in read only mode which I can not do in production. Is it true?

I need to copy a 22G partition from our production to development database.

What is the best way to do this with minimum time spent on resources. I am under the impression that transportable tablespaces feature needs the datafiles in read only mode which I can not do in production. Is it true?

Do you (or the developers) really need 22GB partition in development env? I don't think so.

What you should do is create a partition and insert sample data (may be around 100,000 rows) and update the statistics manually to several million rows. This can be easily achieved through exp/imp with minimum overhead on prod server.

Do the prod and developer databases use the same os? Do you backup your database? Have you tested your restore procedures lately? Why don't you just restore from the backup? If it is a question of disk space, you can always remap the drives as raid 0 while you are doing your testing.