You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

SSB user

edited Apr 16, 2022 7:54AM in Autonomous Database 1 comment

Summary

star schema

Content

hi all

Oracle autonomous has a SSB schema , its an example of star schemas , but the oracle schema is locked.

From our admin user it is not possible to unlock or delete these user , it gaves us 01031. 00000 -  "insufficient privileges"

i want to know if these user has an standard password like scott/tiger ??

it is possible to drop to increate our tables sizes , its an oracle_maintained schema so is correct to drop ??

how can i drop these schema ??

thanks all 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!