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
jgriggsjr
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 Jul 05 18:49:08 CDT 2024