Originally posted by jodie
MH -
I did recycle the db.
I don't really care what it says, except that I want to pull out all of the NON-default values to set when I create the production db (this is a test instance).

So more than anything, I was just curious.

Jodie
v$parameter does have a column called isdefault. You can query based on that column and see which parameters are not default.