oracle10g - restoration of oracle database -
Do i restart the separate dump (databases) on a single database created through the Database Configuration Assistant in Okel 10G Can i I mean the last tablespace should be overwritten by the new, thus we save every time we restore new dump file to create new tablespaces.
Yes it is possible by creating a new user.the new user will act as a new schema and It may exist with previously imported data without overwriting it. If I want to import different data using the same user then the previously stored data must be left with the user; The command to do this is
remove the user cascade; It will leave the previously stored data without removing the tablespace, thus saving time to create new tablespaces.
Comments
Post a Comment