2 Replies Latest reply: Nov 1, 2013 10:33 PM by Fahd.Mirza RSS

    my question

    1050370

      i can do expdp but my question is i am having 10 schemas see for example in all schemas i am having around 150 tbale but i am having one table in common i want only structure but not data in all schemas for that particular table

        • 1. Re: my question
          Alvaro

          Use:

           

          Schema Mode expdp

           

          CONTENT=METADATA_ONLY

          SCHEMAS=HR,SCOTT,ETC

          INCLUDE=TABLE:"IN('TABLE_NAME')"

           

          Table mode expdp:

           

          CONTENT=METADATA_ONLY

          TABLES=user1.table,user2.table,user3.table

          • 2. Re: my question
            Fahd.Mirza

            In Addition to Alvaro's answer, after just getting structure of table through expdp, you can export all of those 10 schemas by excluding that table by using

             

            EXCLUDE=TABLE:"IN ('TABLE NAME)"

             

            regards