oracle

#216

[Oracle] Enable partitions

Olivier | Config

Check if partitionning is enabled or not : To enable partition feature : On Solaris, ‘make’ could be installed using following packages : make libgcc libintl libiconv libintl-3.4.0-sol10-x86-local make-3.82-sol10-x86-local libiconv-1.14-sol10-x86-local libgcc-3.3-sol10-intel-local

Databae, database, linux, oracle, solaris

#36

[Oracle] table stats

Olivier | Tips | 1

Databae, oracle

#15

[Oracle] Import/Export as dump

Olivier | Config, Tips | 6

As sys/sysdba : Export : Import : Export Options : To change the export version : version_string example : 10.2 Import Options : To change destination tablespace add : (in this case, the following grant should be performed : grant imp_full_database to YOURUSER;) In case of multi schema : REMAP_TABLESPACE=(src1:dst1,src2:dst1,src3:dst1,src4:dst1) To change destination schema add […]

backup, export, import, oracle