-
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.
-
exp system/manager file=foo.bar tables=schema1.tabname1, schema1.tabname2, schema2.tabname1
Jeff Hunter
-
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.
-
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
Jeff Hunter
-
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.
-
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
-
thanks folks - that worked!
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
|