OraFAQ Forum: Server Utilities » Schema Expired & Locked after import

Home » RDBMS Server » Server Utilities » Schema Expired & Locked after import (Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit, Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Schema Expired & Locked after import [message #655087]

Sun, 21 August 2016 23:59

praveenpraj
Messages: 21
Registered: October 2011
Location: India

Junior Member

Friends, why Schemas are getting "EXPIRED & LOCKED" automatically after import (impdp).

SELECT resource_name,resource_type,limit FROM dba_profiles WHERE profile='DEFAULT';
RESOURCE_NAME	        RESOURCE_TYPE	LIMIT
COMPOSITE_LIMIT	          KERNEL	UNLIMITED
SESSIONS_PER_USER	  KERNEL	UNLIMITED
CPU_PER_SESSION	          KERNEL	UNLIMITED
CPU_PER_CALL	          KERNEL	UNLIMITED
LOGICAL_READS_PER_SESSION KERNEL	UNLIMITED
LOGICAL_READS_PER_CALL	  KERNEL	UNLIMITED
IDLE_TIME	          KERNEL	UNLIMITED
CONNECT_TIME	          KERNEL	UNLIMITED
PRIVATE_SGA	          KERNEL	UNLIMITED
FAILED_LOGIN_ATTEMPTS	  PASSWORD	10
PASSWORD_LIFE_TIME	  PASSWORD	UNLIMITED
PASSWORD_REUSE_TIME	  PASSWORD	UNLIMITED
PASSWORD_REUSE_MAX	  PASSWORD	UNLIMITED
PASSWORD_VERIFY_FUNCTION  PASSWORD	NULL
PASSWORD_LOCK_TIME	  PASSWORD	1
PASSWORD_GRACE_TIME	  PASSWORD	7

Report message to a moderator

[Message index]

		Schema Expired & Locked after import By: praveenpraj on Sun, 21 August 2016 23:59
		Re: Schema Expired & Locked after import By: John Watson on Mon, 22 August 2016 00:38
		Re: Schema Expired & Locked after import By: Michel Cadot on Mon, 22 August 2016 00:46
		Re: Schema Expired & Locked after import By: rodrigo.jg on Tue, 20 June 2017 16:24
		Re: Schema Expired & Locked after import By: BlackSwan on Tue, 20 June 2017 18:20
		Re: Schema Expired & Locked after import By: rodrigo.jg on Tue, 20 June 2017 18:54

Previous Topic:	Issue in SQL loader control file
Next Topic:	impdp without CREATE USER metadata

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 20:16:16 CDT 2024