|
-
 Originally Posted by newbie5
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.
Tamil
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote