ORACLE:

https://www.youtube.com/watch?v=cZDDI9HFBIU#t=289.322667

https://docs.oracle.com/cd/E11882_01/install.112/e49700/toc.htm#CFHEEEBJ

http://www.kamsoft.pl/servlet/news_viewer/wiad?nr=10187

http://prac.us.edu.pl/~agrzybow/Konfiguracja_serwera_i_klienta_bazy_danych_Oracle10gR2_w_systemie_Windows.pdf

http://andrzejklusiewicz.blogspot.com/2010/12/kurs-administracji-bazami-danych-oracle.html


http://www.oracle.com/pls/db111/homepage      dokumentacja

http://math.uni.lodz.pl/~zysk/materialy.htm
http://www.oracle.com/pls/db102/portal.portal_db?selected=3
http://www.oracle.com/pls/db102/show_mindex

http://blogs.oracle.com/obipl/2010/10/jak_zaczac.html
http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/tutorials/index.html
http://www.oracle.com/technetwork/database/enterprise-edition/index-093639.html

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

Szkolenia:
http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/tutorials/index.html


DUMP:
http://download.oracle.com/otndocs/products/database/enterprise_edition/utilities/pdf/datapump11gr2_twp_rac_1009.pdf

http://download.oracle.com/otndocs/products/database/enterprise_edition/utilities/pdf/datapump11gr2_techover_1009.pdf

http://download.oracle.com/otndocs/products/database/enterprise_edition/utilities/pdf/datapump11gr2_techover_1009.pdf


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

http://www.tidnab.nowaruda.net/linux/379/pompowanie-danych-do-oracla-sql-loader-dbf2sql-dbf2cvs-dbf2ascii.html

oraz tutaj:
http://www.softcov.com/pl/design-and-optimization/oracle--database-backup-and-restore-the-complete.html