1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

metadata_only

Discussion in 'Server Administration and Options' started by noufal_y, Aug 6, 2009.

  1. noufal_y

    noufal_y Forum Advisor

    Messages:
    38
    Likes Received:
    0
    Trophy Points:
    80
    Hi,

    I am new to oracle and i have one schema " ans".
    Some data already there in the DB.
    I need to bring this schema without any data means fresh one.

    Apart from metadata_only exporting is there any other way like deleting........?

    Thanks in advance
     
  2. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    You can import with option rows=No.

    But why do you want to delete ?
     
  3. noufal_y

    noufal_y Forum Advisor

    Messages:
    38
    Likes Received:
    0
    Trophy Points:
    80
    Hi,

    thanks very much. I need to get the schema as clean and fresh for production implementation. Now it has some data with its objects. So please send me your kind advice. I am using OEM and bat files for Exp & imp.


    Best Regards,
    Noufal
     
  4. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India