Porady: http://www.goldenline.pl/forum/1284834/jak-wykonac-eksport-dump-schematu-z-11-do-10 "To have a better performance and more flexibility when exporting from and importing into Oracle10g and higher release databases, we recommend the usage of the Export Data Pump (expdp) and Import Data Pump (impdp) clients" Micha? K.: Jak wykona? eksport (dump) schematu z bazy oracle 11 aby zaimportowa? go potem do 10? za metalinkiem: -- Step 1: export from 11.1.0.6 source database -- with 11.1.0.6 Export Data Pump client and specify VERSION: % expdp system/manager DIRECTORY=my_dir DUMPFILE=expdp_s.dmp LOGFILE=expdp_s.log SCHEMAS=scott VERSION=10.2 -- Step 2: transfer dumpfile to target server -- Step 3: import into 10.2.0.4 target database -- with 10.2.0.4 Import Data Pump client: % impdp system/manager DIRECTORY=my_dir DUMPFILE=expdp_s.dmp LOGFILE=impdp_s.log
INNE TUTORIALE BAZ DANYCH: ftp://bsd.kamsoft.pl/pub/KS-CRM/2010.01.0.0/dokumenty/KSCRM_instalacja.pdf
EXP/IMP db:
http://download.oracle.com/docs/cd/B28359_01/server.111/b28313/cdc.htm#CHDJFBFI Examples of Oracle Data Pump Export and Import Commands
The following are examples of Data Pump export and import commands that support Change Data Capture objects: > expdp DIRECTORY=dpump_dir FULL=y > impdp DIRECTORY=dpump_dir FULL=y STREAMS_CONFIGURATION=y
See Oracle Database Utilities for information on Oracle Data Pump. (link poni?ej:) http://download.oracle.com/docs/cd/B28359_01/server.111/b28319/toc.htm
DATA PUMP IMPORT: http://download.oracle.com/docs/cd/B28359_01/server.111/b28319/dp_import.htm#i1007653
WA?NE: http://www.niusy.bajery.pl/thread/news.onet.pl/pl.comp.bazy-danych/40241 baza zamknela sie, otwarla z nowymi parametrami z init, wszystko ok 2. wykonalem exp full na 1wszym serwerze (bez jakichkolwiek error i warning) 3. wykonalem imp full na 2gim serwerze i niby wszystko ok, tj. przestrzenie tabel sie utworzyly ok, pliki tak jak na 1wszym, imp zakonczyl sie powodzeniem z warningami, no i wlasnie tutaj mam maly problem:
3.1. z tego co zauwarzylem to : w roli (WP_REDAKTOR) jaka mialem utworzyly sie tylko granty postaci: GRANT ALTER ANY PROCEDURE TO WP_REDAKTOR; GRANT ANALYZE ANY TO WP_REDAKTOR; GRANT CONNECT TO WP_REDAKTOR WITH ADMIN OPTION; GRANT WP_REDAKTOR TO ADA; itd... -- i tu ciag grantow dla uzytkownikow
Airlines and travelagencies claim to have the cheapest flights. Flight24.com compare prices from all the leading airlines and travel agencies, so that you as a customer can find the cheapest flights without visiting many websites.