Home » RDBMS Server » Server Utilities » wwsec_persons$ problem when restoring full dmp of 817 portal
wwsec_persons$ problem when restoring full dmp of 817 portal [message #185058] Sun, 30 July 2006 15:33
Messages: 1
Registered: July 2006
Junior Member
Rebuilding a DOA windows 2003 oracle portal server using a full dmp file. When I create the db from scratch and import the dmp file all appears well in the logs with only the usual handful of invalid objects to recompile. User logins are failing however and looking at wwsec_persons$ table tells me why -- it's empty. The import log shows 65,000 records imported into this table and no errors, yet when I query it with count(*) it's 0. Have tried importing just this table into another schema and get the same results -- log says 65k imported but query shows nothing. Anyone seen this behavior with an import before and particularly in the portal30 schema?
Previous Topic: SQLLDR - Removing CR/LF in Text Fields
Next Topic: How to distinguish b/w normal trace file and different Sessions enabled SQL trace files?
Goto Forum:

Current Time: Fri Jun 23 03:55:15 CDT 2017

Total time taken to generate the page: 0.15139 seconds