Why Oracle prepend the Schema name to created procedures?

Question

I'm connecting to a new Oracle database with Toad.

If a create a procedure like:

create or replace procedure MyProc...

After I compile it, the name automatically is changed to

 SchemaName.MyProc

This doesn't happen in other Oracle databases where I'm doing the same test.

Is that a database configuration?

Thanks!

Answer 1

If you open TOAD settings, you'll find it here:

1. Editor - Open/save
2. Object loading
3. if set to "Always include", you'll see owner name (SCOTT in my example)
4. if you set it to "Never include", owner name isn't visible any more