Oracle a modo mio - Cronologia

WikiSysop: /* svuota schema */

2024-03-26T11:28:22Z

svuota schema

← Versione meno recente		Versione delle 11:28, 26 mar 2024
Riga 206:		Riga 206:
	end;		end;
	/		/


	begin		begin
	for c1 in (select owner,object_name,object_type from dba_objects where owner='&1' and object_type !='JOB')		for c1 in (select owner,object_name,object_type from dba_objects where owner='&1' and object_type !='JOB')

2024-03-26T11:27:28Z

svuota schema

← Versione meno recente		Versione delle 11:27, 26 mar 2024
Riga 198:		Riga 198:
	loop		loop
	begin		begin
	execute immediate 'drop table ' \|\| c1.owner \|\| '.' \|\| c1.table_name \|\| ' cascade constraints';		execute immediate 'drop table ' \|\| c1.owner \|\| '."' \|\| c1.table_name \|\| '" cascade constraints';
	exception		exception
	when others then		when others then
Riga 211:		Riga 211:
	loop		loop
	begin		begin
	execute immediate 'drop ' \|\| c1.object_type \|\| ' ' \|\| c1.owner \|\| '.' \|\| c1.object_name ;		execute immediate 'drop ' \|\| c1.object_type \|\| ' ' \|\| c1.owner \|\| '."' \|\| c1.object_name \|\| '"';
	exception		exception
	when others then		when others then

2023-11-08T11:24:53Z

impdp

← Versione meno recente		Versione delle 11:24, 8 nov 2023
Riga 249:		Riga 249:
	directory=DPUMP_DIR		directory=DPUMP_DIR
	logfile=impdp_tabella_singola.log		logfile=impdp_tabella_singola.log
	network_link=~~impdp_daol_prod~~		network_link=impdp_database_prod
	tables=esempio.tabella01		tables=esempio.tabella01
	remap_schema=ESEMPIO:NUOVOSCHEMA1		remap_schema=ESEMPIO:NUOVOSCHEMA1

2023-11-08T11:23:36Z

impdp

← Versione meno recente		Versione delle 11:23, 8 nov 2023
Riga 256:		Riga 256:
	exclude=statistics,grant		exclude=statistics,grant
	transform=DISABLE_ARCHIVE_LOGGING:Y,OID:N		transform=DISABLE_ARCHIVE_LOGGING:Y,OID:N

			Opzioni possibili:

			transform=table_compression_clause:"ROW STORE COMPRESS ADVANCED"
			transform=lob_storage:securefile

	<code>systimestamp</code> ritorna sempre un <code>timestamp with time zone</code>.		<code>systimestamp</code> ritorna sempre un <code>timestamp with time zone</code>.

2023-05-22T12:02:34Z

optimizer_adaptive_features

← Versione meno recente		Versione delle 12:02, 22 mag 2023
Riga 144:		Riga 144:
	alter system set optimizer_adaptive_features=false scope=both sid='*';		alter system set optimizer_adaptive_features=false scope=both sid='*';

	Con versione 12.2 le funzioni del parametro sono state divise in due parametri diversi:		Con versione 12.2 le funzioni del parametro sono state divise in due parametri diversi, per cui non serve modificare il default:
	optimizer_adaptive_plans boolean TRUE		optimizer_adaptive_plans boolean TRUE
	optimizer_adaptive_statistics boolean FALSE		optimizer_adaptive_statistics boolean FALSE

2023-05-22T12:02:01Z

optimizer_adaptive_features

← Versione meno recente		Versione delle 12:02, 22 mag 2023
Riga 146:		Riga 146:
	Con versione 12.2 le funzioni del parametro sono state divise in due parametri diversi:		Con versione 12.2 le funzioni del parametro sono state divise in due parametri diversi:
	optimizer_adaptive_plans boolean TRUE		optimizer_adaptive_plans boolean TRUE
	optimizer_adaptive_statistics boolean FALSE		optimizer_adaptive_statistics boolean FALSE

	==default bigfile==		==default bigfile==

2023-05-22T12:01:36Z

optimizer_adaptive_features

← Versione meno recente		Versione delle 12:01, 22 mag 2023
Riga 143:		Riga 143:
	== optimizer_adaptive_features ==		== optimizer_adaptive_features ==
	alter system set optimizer_adaptive_features=false scope=both sid='*';		alter system set optimizer_adaptive_features=false scope=both sid='*';

			Con versione 12.2 le funzioni del parametro sono state divise in due parametri diversi:
			optimizer_adaptive_plans boolean TRUE
			optimizer_adaptive_statistics boolean FALSE

	==default bigfile==		==default bigfile==

2023-02-27T09:15:46Z

impdp

← Versione meno recente		Versione delle 09:15, 27 feb 2023
Riga 238:		Riga 238:

	impdp "'/ as sysdba'" directory=DUMP01 logfile=impdp_dblink_01.log network_link=dblink_impdp01 exclude=statistics \		impdp "'/ as sysdba'" directory=DUMP01 logfile=impdp_dblink_01.log network_link=dblink_impdp01 exclude=statistics \
	schemas=~~USER0101~~ flashback_time='"to_timestamp_tz(systimestamp)"' transform=DISABLE_ARCHIVE_LOGGING:Y,OID:N		schemas=USER01 flashback_time='"to_timestamp_tz(systimestamp)"' transform=DISABLE_ARCHIVE_LOGGING:Y,OID:N

	via dblink con parfile:		via dblink con parfile:

2023-02-27T09:15:29Z

impdp

← Versione meno recente		Versione delle 09:15, 27 feb 2023
Riga 238:		Riga 238:

	impdp "'/ as sysdba'" directory=DUMP01 logfile=impdp_dblink_01.log network_link=dblink_impdp01 exclude=statistics \		impdp "'/ as sysdba'" directory=DUMP01 logfile=impdp_dblink_01.log network_link=dblink_impdp01 exclude=statistics \
	flashback_time='"to_timestamp_tz(systimestamp)"' transform=DISABLE_ARCHIVE_LOGGING:Y		schemas=USER0101 flashback_time='"to_timestamp_tz(systimestamp)"' transform=DISABLE_ARCHIVE_LOGGING:Y,OID:N

	via dblink con parfile:		via dblink con parfile:

2022-07-04T18:29:49Z

svuota schema

← Versione meno recente		Versione delle 18:29, 4 lug 2022
Riga 191:		Riga 191:
	alter session set recyclebin=off;		alter session set recyclebin=off;
	begin		begin
	for c1 in (select table_name from dba_tables where owner='&1')		for c1 in (select owner,table_name from dba_tables where owner='&1')
	loop		loop
	begin		begin
	execute immediate 'drop table ~~detica2~~.' \|\| c1.table_name \|\| ' cascade constraints';		execute immediate 'drop table ' \|\| c1.owner \|\| '.' \|\| c1.table_name \|\| ' cascade constraints';
	exception		exception
	when others then		when others then