Home » Server Options » Data Guard » Import a schema (tables, Views, Stored Procedures) on logical standby (RDBMS Version: 10.2.0.3, Operating System and Version: Microsoft Windows 2003 (x86) Version 2003)
Import a schema (tables, Views, Stored Procedures) on logical standby [message #319488] |
Sun, 11 May 2008 21:30 |
sallooooo
Messages: 1 Registered: May 2008
|
Junior Member |
|
|
Hi,
We have a logical standby for reporting purpose. The logical standby build through data guard
we need to import a new user in logical standby using import utility. The user dump contain tables, views, procedures, packages, roles).
The new user import has to go in users tablespace.
Is is possbile to import a new user in logical standby and what are the steps.
Thanks in advance
|
|
|
Re: Import a schema (tables, Views, Stored Procedures) on logical standby [message #340006 is a reply to message #319488] |
Sun, 10 August 2008 23:46 |
email.sandeepnaik
Messages: 121 Registered: August 2006
|
Senior Member |
|
|
yes.
You have 3 modes for logical
guard all ,guard standby and guard none
Guard all will not allow any changes to db other than sys and lsp.
Guard none will allow lsp to do its job as well allow other users to own their schema and any other schema
Guard standby will allow other use to update data which is created by them and not modified by LSP
In your case
1 mount db
2 alter database guard standby
3 alter database open
4 create user
5 then run import this should import data in new user and this new user should be now able to perform all DML on data which is imported.
Sandeep
|
|
|
Goto Forum:
Current Time: Sat Jan 11 06:03:18 CST 2025
|