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 Go to next message
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 Go to previous message
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
Previous Topic: Logical Standby Apply became TOO SLOW !!
Next Topic: Primary database
Goto Forum:
  


Current Time: Thu Dec 08 06:22:39 CST 2016

Total time taken to generate the page: 0.11321 seconds