Export Tables

[sukimac]

Hi Everyone,

Is there a way to create an export file that exports all the tables from a schema, but, only the rows from certain tables?
Thanks for the help.

[marist89]

exp system/manager file=foo.bar tables=schema1.tabname1, schema1.tabname2, schema2.tabname1

[sreddy]

Could you explain clearly.

Whats the purpose of this export ? for back up ? to create replica of schema ?

I don't see the reason, to export all the tables and certain tables data. Export everything, I mean all the tables of schema with data and control your import with what you wanted tables ddl/tables data.

[marist89]

Ah, I didn't get that part...
1. exp system/manager file=foo1.bar owner=schema1 rows=n
2. exp system/manager file=foo2.bar tables=schema1.tab1, schema1.tab2, schema1.tab3
3. imp system/manager file=foo1.bar full=y
4. imp system/manager file=foo2.bar full=y ignore=y

[sukimac]

let me explain what we're trying to do - we want to export one schema from a test box into a test schema on a production box. I don't want to import rows from certain tables (dynamic tables like prod listings) but I do want rows from certain tables (categories). I know there are other methods of setting up a testing environment but we've opted for creating test schemas. Thanks for the help.

[xyz2000]

exp system/manager owner=schema1 file=file1.dmp
imp system/manager file=file1.dmp fromuser=schema1 touser=schema2 rows=n
imp system/manager file=file1.dmp fromuser=schema1 tables=table1,table2,table3 touser=schema2 ignore=y

[sukimac]

thanks folks - that worked!