Fulltext results:

Oracle: SPFile and PFiles

4 Hits, Last modified: 13 years ago

s ====== Oracle reads its parameters from a file called "SPFile". You can't change it directly as it's a binary file. Additionally, Oracle can read the parameters from "PFiles", which are reg... ; SHUTDOWN IMMEDIATE; </code> If your PFile is located at ''/db/oracle/config/pfiles/initweb.ora'', t

Oracle: List Accounts with Objects

2 Hits, Last modified: 13 years ago

l accounts (users) the objects (like tables), you can query them with: <code sql> SELECT DISTINCT OWN... R; </code> If you want to list all accounts, you can query them with: <code sql> SELECT USERNAME FRO