Tech-Today
The following steps will guide us in the restoration of an oracle dump file.
- How To Dump And Restore A Postgresql Database
To create a postgresql dump in linux, execute the following commands: Login as root user>su - postgres>pg_dump -U username -W -Z 9 -f /tmp/dump_username.dump.zip -h 127.0.0.1 dbname>passwordTo restore, execute: >psql -U username -f dump_username.dump dbnameOther...
- Database
MSSQLMSSQL equivalent of DESC in MYSQLPostgresqlChange postgresql's postgres passwordHow to install hstore in postgresql 9.1JDBC provider setting in java for postgresql, mysql and oracleHow to alter the sequence value in postgresqlOracleHow to change...
- How To Setup Postgresql In Ubuntu 11.10 And Perform Dump/restore
This write up will try to explain how to install postgresql and attempt to perform database dump and restore. Which should be a basic functionality but is not present in pgadmin. 1.) Install postgresql (execute in terminal): sudo apt-get install...
- Ora-12519, Tns:no Appropriate Service Handler Found
I often encountered this error after setting up a new machine with jboss/seam/oracle project installed. To resolve this: 1.) Open command prompt, by typing cmd in Start 2.) Execute c:\windows\system\sqlplus system@YOUR_SID 3.) Execute "ALTER SYSTEM SET...
- How To Change The Default Http And Ftp Port In Oracle Xe Univ
We assume that you have successfully download and installed the OracleXEUniv.exe. How to change the default http and ftp port in oracle xe univ 1.) Click Start->Run 2.) Type C:\Windows\System32\sqlplus system@xe 3.) Enter the admin password 4.) Enter...
Tech-Today
How to restore an oracle dump using imp command
The following steps will guide us in the restoration of an oracle dump file.
- connect as system and enter your password
- create user
- grant roles
- create permanent table space
- import the dump file
sqplus system@xe
create user TEST_USER identified by password;
grant CREATE SESSION, ALTER SESSION, CREATE DATABASE LINK, -
CREATE MATERIALIZED VIEW, CREATE PROCEDURE, CREATE PUBLIC SYNONYM, -
CREATE ROLE, CREATE SEQUENCE, CREATE SYNONYM, CREATE TABLE, -
CREATE TRIGGER, CREATE TYPE, CREATE VIEW, UNLIMITED TABLESPACE -
to TEST_USER;
CREATE TABLESPACE testuser DATAFILE 'testuser.dat' SIZE 20M AUTOEXTEND ON;
imp system/password@xe file=d:\testuser.dmp fromuser=TEST_USER touser=TEST_USER log=d:\test_user_import.log
- How To Dump And Restore A Postgresql Database
To create a postgresql dump in linux, execute the following commands: Login as root user>su - postgres>pg_dump -U username -W -Z 9 -f /tmp/dump_username.dump.zip -h 127.0.0.1 dbname>passwordTo restore, execute: >psql -U username -f dump_username.dump dbnameOther...
- Database
MSSQLMSSQL equivalent of DESC in MYSQLPostgresqlChange postgresql's postgres passwordHow to install hstore in postgresql 9.1JDBC provider setting in java for postgresql, mysql and oracleHow to alter the sequence value in postgresqlOracleHow to change...
- How To Setup Postgresql In Ubuntu 11.10 And Perform Dump/restore
This write up will try to explain how to install postgresql and attempt to perform database dump and restore. Which should be a basic functionality but is not present in pgadmin. 1.) Install postgresql (execute in terminal): sudo apt-get install...
- Ora-12519, Tns:no Appropriate Service Handler Found
I often encountered this error after setting up a new machine with jboss/seam/oracle project installed. To resolve this: 1.) Open command prompt, by typing cmd in Start 2.) Execute c:\windows\system\sqlplus system@YOUR_SID 3.) Execute "ALTER SYSTEM SET...
- How To Change The Default Http And Ftp Port In Oracle Xe Univ
We assume that you have successfully download and installed the OracleXEUniv.exe. How to change the default http and ftp port in oracle xe univ 1.) Click Start->Run 2.) Type C:\Windows\System32\sqlplus system@xe 3.) Enter the admin password 4.) Enter...