The Production has nothing to do with your database/instance name.
It is the Production Release of the Oracle RDBMS.
Your database/instance name could be anything.
You cannot change the label provided by Oracle when you
connect to the database [unless you try hacking the source code
and
Title: connection output on clone instance
can anyone guide me in changing the connect output:
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
With the Partitioning option
JServer Release 8.1.7.2.0 - Production
Where Production will be replaced with TEST