Tech-Today
- 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...
- 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 passwordsqplus system@xe create usercreate user TEST_USER identified by password; grant rolesgrant CREATE SESSION, ALTER SESSION, CREATE DATABASE...
- How To Import And Export A Database Dump In Oracle
The following instruction will help us in importing and exporting our oracle database. Create and restore dump file (http://www.database.fi/2011/05/using-expdp-and-impdp-export-and-import-in-10g-11g/)Create dump filesqlplus system/oracleSQL> create...
- How To Setup Toad Oracle Freeware
The following article will help us in configuring our Toad Oracle Freeware with Oracle XE database. For development purposes I normally use XE so it's light. Steps: Download and install Oracle XE - I use 10.2.xI installed in: C:\java\oraclexeDownload...
- Jdbc Provider Setting In Java For Postgresql, Mysql And Oracle
Below are the summary of connection settings for differenct jdbc provider: Database Connection Url Driver Class Hibernate Dialect Cache Provider Class PostgreSQL jdbc:postgresql://[host]:[port]/[db] org.postgresql.Driver org.hibernate.dialect.PostgreSQLDialect...
Tech-Today
Database
MSSQL
- MSSQL equivalent of DESC in MYSQL
Postgresql
- Change postgresql's postgres password
- How to install hstore in postgresql 9.1
- JDBC provider setting in java for postgresql, mysql and oracle
- How to alter the sequence value in postgresql
Oracle
- How to change the default http and ftp port in oracle xe universe
- How to restore an oracle dump using imp command
- How to setup Toad Oracle Freeware
- How to import and export a database dump in oracle
- 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...
- 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 passwordsqplus system@xe create usercreate user TEST_USER identified by password; grant rolesgrant CREATE SESSION, ALTER SESSION, CREATE DATABASE...
- How To Import And Export A Database Dump In Oracle
The following instruction will help us in importing and exporting our oracle database. Create and restore dump file (http://www.database.fi/2011/05/using-expdp-and-impdp-export-and-import-in-10g-11g/)Create dump filesqlplus system/oracleSQL> create...
- How To Setup Toad Oracle Freeware
The following article will help us in configuring our Toad Oracle Freeware with Oracle XE database. For development purposes I normally use XE so it's light. Steps: Download and install Oracle XE - I use 10.2.xI installed in: C:\java\oraclexeDownload...
- Jdbc Provider Setting In Java For Postgresql, Mysql And Oracle
Below are the summary of connection settings for differenct jdbc provider: Database Connection Url Driver Class Hibernate Dialect Cache Provider Class PostgreSQL jdbc:postgresql://[host]:[port]/[db] org.postgresql.Driver org.hibernate.dialect.PostgreSQLDialect...