thanks for prompt response.there is another way, you can restore the database using backup.
I was looking for some option while database to be online....only for schema restoration.
please help !!!
Any other option to restore schema??As it has been discussed in another thread, the schema is not a physical thing, it is a logical set of objects that user has.