URGENT PLS HELP!!!

[kevlar]

OS => IBM AIX 4.3
DB => ORACLE v8.1.6

i am exporting a prod db to a test db. can I decrease the size
of each table from the prod db then import it with the test db.

eg:

PROD =>
FINANCIALS -> tablespaces of 4GB
-> TBL_GL -> initial extent of 100M next is 100M
-> TBL_TRAN_HIST -> initial extent of 300M next is 300M


and i want to import this configs to the test environment using this storage:

TEST =>
FINANCIALS -> tablespaces of 2GB
-> TBL_GL -> initial extent of 500K next is 500K
-> TBL_TRAN_HIST -> initial extent of 500K next is 500K


is this possible???? pls help.......

[pando]

just 2 tables? it's a piece of cake if so

[kevlar]

that's only a sample, they are maybe up to 20 of those in one tablespace and around 134 in that schema that I want to export

[kevlar]

can someone please advice....

[vinit]

Why would u want to do that..create the tables in the test db with the proper sizing parameters. Then take an export of the tables u want and import them back to test with ignore=y option. Hope this helps.


Cheers,

[kevlar]

our test db has garbled data, now they want to put the product data to the test db. meaning they want to refresh the contents of the test db. but not the same size of the prod......