Skip to main content

Oracle export /backup and import /restore schemas

A----------------------------------------EXPORT/BACKUP----------------------------------------------------

 1-
 make new folder for the backup  let say c:/oracle/import/MY_DATA_PUMP_DIRECTORY

 2- 
sqlplus  login as system user
3-
CREATE DIRECTORY MY_DATA_PUMP_DIRECTORY AS 'c:/oracle/MY_DATA_PUMP_DIRECTORY';


4-
grant all on directory MY_DATA_PUMP_DIRECTORY to system;

 5- exit sqlplus and run the following from command line

 expdp system/password DIRECTORY=MY_DATA_PUMP_DIRECTORY DUMPFILE=schemaName.dmp logfile=schemaName.log SCHEMAS=schemaName
B-----------------------------IMPORT/RESTORE--------------------------------------------------------------------

1- make sure you have the directory  MY_DATA_PUMP_DIRECTORY   the same as for the import

2-
impdp system/password  DIRECTORY=MY_DATA_PUMP_DIRECTORY dumpfile=schemaName.dmp logfile=schemaName.log SCHEMAS=schemaName

Comments

Post a Comment

Popular posts from this blog

itext 2.7.1 writing Arabic and English content in a PDF file

   public void createPdf(String filename) throws IOException, DocumentException {               Document document = new Document();           PdfWriter.getInstance(document, new FileOutputStream(filename));             document.open();             document.add(Chunk.NEWLINE);        FontFactory.register("c:/windows/fonts/tradbdo.ttf", "my_arabic");               Font myArabicFont = FontFactory.getFont("my_arabic" ,BaseFont.IDENTITY_H, BaseFont.EMBEDDED);         PdfPTable table = new PdfPTable(1);         table.getDefaultCell().setNoWrap(false);        // table.setRunDirection(PdfWriter.RUN_DIRECTION_RTL);         PdfPCell text = new PdfPCell(new Phrase("محمود السنباطيthis is أبتثجحخدرزسشصضطظعغفقكلمنهوى", myArabicFont));         text.setRunDirection(PdfWriter.RUN_DIRECTION_RTL);          text.setNoWrap(false);          table.addCell(text);     //Add the table to the document         document.add(table);                  
3 comments
Read more

Installing liferay 6.2 on wildfly 10 app server and oracle 11g database & windows machine

*************************************DATABASE CREATION*********************************************************************************************** DOWNLOAD LIFERAY PORTAL SCRIPTS FROM https://www.liferay.com/downloads/liferay-portal/available-releases Rename the file as liferay.sql put it let say in under c drive , so it will be located like this  c:\liferay.sql from cmd dir c:\ SQLPLUS / AS SYSDBA @liferay.sql lportal lportal it will create the db ..after finishing go to sqlplus again to ggrant the below  to lportal user SQLPLUS / AS SYSDBA grant create session to lportal; grant connect to lportal; grant resource to lportal; *******************************CONFIGURE WILDFLY TO CONNECT TO ORACLE DB *****************************************************************************************************  configure wildfly to connect to oracle db Download the driver: ojdbc[VERSION].jar Create subfolders [WILDFLY_HOME]/modules/system/layers/base/com/oracle/main/ C
7 comments
Read more

Fast Download with progress indication facility using Java NIO

package test; import java.io.FileOutputStream; import java.io.IOException; import java.net.HttpURLConnection; import java.net.URL; import java.nio.ByteBuffer; import java.nio.channels.Channels; import java.nio.channels.ReadableByteChannel; import java.util.Date; public class DownloadProgressExample {     public static void main( String[] args ) {         new Downloader( "c:/header12.jpg", "http://www.daralshifa.com/images/mainheader/header12.jpg" );     }     private interface RBCWrapperDelegate {          // The RBCWrapperDelegate receives rbcProgressCallback() messages         // from the read loop.  It is passed the progress as a percentage         // if known, or -1.0 to indicate indeterminate progress.         //         // This callback hangs the read loop so a smart implementation will         // spend the least amount of time possible here before returning.         //         // One possible implementation is to push the progress message         // atomic
Post a Comment
Read more