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 touser=DESTINATIONUSER
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 fix, connect as sysdba: SHOW […]
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 DB tries once every 60 […]
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 the rows for all tables […]
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 /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh At this point, is […]
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