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