To import an Oracle exported file with *nix command line, use this command: imp \’/ as sysdba\’ file=expdat.dmp fromuser=ORIGINALUSER touser=DESTINATIONUSERimp \’/ as sysdba\’ file=expdat.dmp fromuser=ORIGINALUSER…
If the database is running, probably the database hasn’t registered yet with the listener. This occurs when the database or listener just starts up. To…
No listener.ora file is required for LISTENER to operate. Try to move, rename, remove, or delete listener.ora file & then restart the listener. Every Oracle…
Counting all of the rows in a schema can require code that actually counts the table rows so, how do you count up all of…
To be able to admin Oracle instance from sqlplus command line on Ubuntu server, for first you need to set the enviroment variables: source /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.shsource…
To install Orace 11gR2 Express Edition, please take a look to this tutorial (tutorial? THE TUTORIAL!) https://forums.oracle.com/forums/thread.jspa?threadID=2301639