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 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...
- Connect To Oracle Database In Java Language
This code connects to an oracle database using java programming language. This to remember: 1.) You must add ojdbc14.jar to the project's build path. 2.) Oracle's driver name: oracle.jdbc.driver.OracleDriver 3.) Connection string: jdbc:oracle:client:@server:port:database...
- Magento Export And Import Products With Images
How to Export Magento Products 1.) login to the magento admin 2.) go to System->Import/Export->Profiles 3.) select Export All Products 4.) select Run Profile and on the middle-right click the "Run Profile in Popup", this will open a new tab...
Tech-Today
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 file
- sqlplus system/oracle
- SQL> create directory dmpdir AS 'c:\temp';
- select directory_name, directory_path from dba_directories;
- expdp system/password version=’10.2.0.1’ dumpfile=czetsuya.dmp directory=dmpdir schemas=czetsuya
- Restore a dump file
- For import we can use the DATA_PUMP_DIR setting:
- ORACLE_XE\app\oracle\admin\XE\dpdump
- Copy dump file to folder above
- impdp system/password dumpfile=czetsuya.dmp directory=DATA_PUMP_DIR full=y logfile=czetsuya.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...
- 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 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...
- Connect To Oracle Database In Java Language
This code connects to an oracle database using java programming language. This to remember: 1.) You must add ojdbc14.jar to the project's build path. 2.) Oracle's driver name: oracle.jdbc.driver.OracleDriver 3.) Connection string: jdbc:oracle:client:@server:port:database...
- Magento Export And Import Products With Images
How to Export Magento Products 1.) login to the magento admin 2.) go to System->Import/Export->Profiles 3.) select Export All Products 4.) select Run Profile and on the middle-right click the "Run Profile in Popup", this will open a new tab...