I have a table partition (135GB) and index partition on this table (total=150GB) and I want to exclude owner schema of this table and indexes with excluding this table partition and it's indexes.
What is the correct syntax for this?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
Your question is a bit confusing. You say you want to "exclude owner schema of this table", but then go on to say "with excluding this table partition and it's indexes" (italics/emphasis mine). If you exclude the owner, you will certainly exclude that table .. along with all other objects under that owner/schema.
That said, the expdp 'exclude' command appears to have enough flexibility to do what you want. It's in the official docs, at https://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_export.htm#SUTIL847