OraFAQ Forum: Server Administration » Create a smaller dev db from prod db

Home » RDBMS Server » Server Administration » Create a smaller dev db from prod db

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Create a smaller dev db from prod db [message #56849]

Wed, 30 April 2003 08:59

Todd Taylor
Messages: 2
Registered: April 2003

Junior Member

I have a 50GB production database running on our production HP-UX server. I would like to create smaller version of the database on our development server. However, the development server only has about 12 GB of disk space. What's the best approach to create a smaller version of the production database on the my development server?

Report message to a moderator

Re: Create a smaller dev db from prod db [message #56851 is a reply to message #56849]

Wed, 30 April 2003 10:24

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

what do u mean smaller version?
Do u want the selective / partial data loaded from production to test or wat?

Report message to a moderator

Re: Create a smaller dev db from prod db [message #56853 is a reply to message #56851]

Wed, 30 April 2003 11:19

Todd Taylor
Messages: 2
Registered: April 2003

Junior Member

I would like to maintain exact copy of the database objects but with only a small subset of the data for testing purposes.

Report message to a moderator

Re: Create a smaller dev db from prod db [message #56872 is a reply to message #56849]

Thu, 01 May 2003 09:07

Eugene
Messages: 44
Registered: August 2001

Member

Hi,
Based on the version of your d/base, if you are on 9iR2, then look at the data subsetter in OEM (not 817's OEM). Also, take a look at Quest's Toad. It has some functionality to generate percentage of data per schema. If you are looking for just a data then you can use scripts which will generate sample random data.

Hope it helps,

Report message to a moderator

Previous Topic:	ORA:01187
Next Topic:	Verification test failure.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 30 15:53:34 CST 2024