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: Export/import full database query
Next Topic: SQL Loader
Goto Forum:
  


Current Time: Wed Aug 23 22:10:40 CDT 2017

Total time taken to generate the page: 0.06035 seconds