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
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
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 parameter LOCAL listenershow parameter local listener If something or nothing
Listener refused the connection with the following error:12505
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 seconds to register itself with LISTENER as shown below: tail
Row count for all tables in schema
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 in a schema? For Oracle with system user: SELECT TABLE_NAME,
Oracle admin on Ubuntu server
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 possible to login as sysdba using: sqlplus / as sysdbasqlplus
Oracle 11gR2 Express Edition on Linux Ubuntu 11.10 howto
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