Home » RDBMS Server » Server Administration » Export to create a test schema
Export to create a test schema [message #134492] Thu, 25 August 2005 04:02 Go to next message
Zakkhalid
Messages: 47
Registered: April 2005
Member
Hi All,

I have a live schema which has over a hundred tables and indexes. I want to recreate the schema as test schema on a different machine. However the tables and indexes are huge (smallest table holds 10million records.)

So I want recreate the schema by with all the objects recreated with much smaller objects.

I've carried out an export with data, and created a indexfile which gives the create statement, but because on the number of objects its abit impractical.

Any advice would be greatly appreicated.

Thanks,
Zak

Report message to a moderator

Re: Export to create a test schema [message #134498 is a reply to message #134492] Thu, 25 August 2005 05:05 Go to previous message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
You can use export utility & specify a query clause like "where rownum<=100" for exporting tables data.

Regds
Girish

Report message to a moderator

Previous Topic: UNABLE TO LOGIN
Next Topic: Subpartition on Date column
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 26 11:18:35 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.