I've downloaded Oracle 10 from oracle.com for testing and have a problem to start sqlplus.
I can login as: sqlplus "/ as sysdba"
but when I wanted to test an example and try to start sqlplus and login as SCOTT/TIGER with Host String "orcl" I've got and error:
ORA-12514 TNS: listener does not currently know of service requested in connect descriptor
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
This post first appeared at Oracleinaction (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself).
I will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines