How to import the user level backup in traditional logical backups? I have exported a schema and later dropped it, now I want to import it.
How can i archive this?
The traditional import you can import directly, but create the schema user first with the underlying datafiles if it has been dropped that will do it.
Or if you want to import on different schema try from user to user in imp command.
Will provide you the options.
I recreated a dropped schema and then imported the whole data of it by giving the options fromuser=shiva touser=shiva...But my doubt is :the whole database import wont require the recreation of dropped schemas, it automatically recreates them but, at user level import it is is not recreating the dropped schema automatically why?
Sign up for STechies
All the site contents are Copyright © www.stechies.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies. The site www.stechies.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity. Information used on this site is at your own risk.
The content on this site may not be reproduced or redistributed without the express written permission of
www.stechies.com or the content authors.