Oracle - Versionsgeschichte

Admin am 14. Juni 2013 um 07:02 Uhr

2013-06-14T07:02:14Z

← Nächstältere Version		Version vom 14. Juni 2013, 07:02 Uhr
Zeile 68:		Zeile 68:
	</source>		</source>

			= Drop Tempfile =
			Platz, den das Tempfile belegt:
			<source lang="sql">
			SELECT tablespace_name, file_name, bytes FROM dba_temp_files WHERE tablespace_name = 'TEMP';
			</source>


			<source lang="text">
			TABLESPACE_NAME FILE_NAME BYTES
			----------------- -------------------------------- --------------
			TEMP /TESTDB/temp01.dbf 13,107,200,000
			</source>


			<source lang="sql">
			ALTER DATABASE TEMPFILE '/TESTDB/temp01.dbf' DROP INCLUDING DATAFILES;
			ALTER TABLESPACE temp ADD TEMPFILE '/TESTDB/temp01.dbf' SIZE 512m AUTOEXTEND ON NEXT 250m MAXSIZE UNLIMITED;
			</source>

			ggf. muss man das Temp-File noch per Hand im Dateisystem löschen
	== Einfach mal merken: ==		== Einfach mal merken: ==

2013-05-06T11:15:09Z

← Nächstältere Version		Version vom 6. Mai 2013, 11:15 Uhr
Zeile 1:		Zeile 1:
			= Neue Version =
			== Export ==
			Tbd

			== Import ==
			<source lang="text">
			export ORACLE_SID=<DB_Instance>
			imp system/<password> parfile=<paramter_file>
			</source>

			Dabei könnte die Parameterdatei folgendermaßen aussehen:

			<source lang="text">
			FILE=<dumpfile>.dmp
			FROMUSER=<User1>,<User2>
			TOUSER=<User1_neu>,<User2_neu>
			LOG=<logfile>.log
			</source>

			= Alte Version =
	== Export ==		== Export ==
	=== Per Kommandozeile ===		=== Per Kommandozeile ===

2013-05-02T09:22:59Z

Einfach mal merken:

← Nächstältere Version		Version vom 2. Mai 2013, 09:22 Uhr
Zeile 65:		Zeile 65:
	<source lang="sql">		<source lang="sql">
	ALTER USER benutzer ACCOUNT UNLOCK;		ALTER USER benutzer ACCOUNT UNLOCK;
	ALTER USER user_name ~~IDENTIIED~~ BY new_password;		ALTER USER user_name IDENTIFIED BY new_password;
	</source>		</source>

2013-05-02T09:22:34Z

← Nächstältere Version		Version vom 2. Mai 2013, 09:22 Uhr
Zeile 61:		Zeile 61:
	)		)
	Select Rid From Zuloeschen);		Select Rid From Zuloeschen);
			</source>

			<source lang="sql">
			ALTER USER benutzer ACCOUNT UNLOCK;
			ALTER USER user_name IDENTIIED BY new_password;
	</source>		</source>

2013-01-21T09:43:49Z

Per Kommandozeile

← Nächstältere Version		Version vom 21. Januar 2013, 09:43 Uhr
Zeile 28:		Zeile 28:
	create or replace directory dump_dir_ref as '/home/oracle/dumps';		create or replace directory dump_dir_ref as '/home/oracle/dumps';
	create user <user> identified by <password>;		create user <user> identified by <password>;
	grant all privileges to ~~aut_gaf_t1_20111222~~;		grant all privileges to <user>;
	</source>		</source>

2012-12-12T14:26:17Z

Per Kommandozeile

← Nächstältere Version		Version vom 12. Dezember 2012, 14:26 Uhr
Zeile 26:		Zeile 26:
	=== Per Kommandozeile ===		=== Per Kommandozeile ===
	<source lang="sql">		<source lang="sql">
	create or replace directory ~~dump_dir~~ as '/home/oracle/dumps';		create or replace directory dump_dir_ref as '/home/oracle/dumps';
	create user <user> identified by <password>;		create user <user> identified by <password>;
	grant all privileges to aut_gaf_t1_20111222;		grant all privileges to aut_gaf_t1_20111222;
Zeile 34:		Zeile 34:
	<source lang="text">		<source lang="text">
	export ORACLE_SID=<DB_Instance>		export ORACLE_SID=<DB_Instance>

	impdp system/<password> parfile=<paramter_file>		impdp system/<password> parfile=<paramter_file>
	</source>		</source>
Zeile 42:		Zeile 41:
	<source lang="text">		<source lang="text">
	DUMPFILE=<dumpfile>.dmp		DUMPFILE=<dumpfile>.dmp
	DIRECTORY=~~dump_directory~~		DIRECTORY=dump_dir_ ref # siehe CREATE or REPLACE
	LOGFILE=<logfile>.log		LOGFILE=<logfile>.log
	JOB_NAME=<Jobname_beliebig>		JOB_NAME=<Jobname_beliebig>
Zeile 48:		Zeile 47:
	REMAP_SCHEMA=<altes_Schema>:<neues_Schema>		REMAP_SCHEMA=<altes_Schema>:<neues_Schema>
	</source>		</source>



	== Einfach mal merken: ==		== Einfach mal merken: ==

2012-12-12T14:25:44Z

Per Kommandozeile

← Nächstältere Version		Version vom 12. Dezember 2012, 14:25 Uhr
Zeile 11:		Zeile 11:
	<source lang="text">		<source lang="text">
	DUMPFILE=<dumpfile>.dmp		DUMPFILE=<dumpfile>.dmp
	DIRECTORY=~~dump_directory~~		DIRECTORY=dump_dir_ref # siehe CREATE or REPLACE
	LOGFILE=<logfile>.log		LOGFILE=<logfile>.log
	JOB_NAME=<Jobname_beliebig>		JOB_NAME=<Jobname_beliebig>
Zeile 20:		Zeile 20:

	<source lang="sql">		<source lang="sql">
	~~create~~ or ~~replace~~ directory ~~dump_dir~~ as '/home/oracle/dumps';		CREATE or REPLACE directory dump_dir_ref as '/home/oracle/dumps';
	</source>		</source>

2012-12-12T12:48:09Z

Per Kommandozeile

← Nächstältere Version		Version vom 12. Dezember 2012, 12:48 Uhr
Zeile 4:		Zeile 4:
	<source lang="text">		<source lang="text">
	export ORACLE_SID=<DB_Instance>		export ORACLE_SID=<DB_Instance>

	expdp system/<password> parfile=<paramter_file>		expdp system/<password> parfile=<paramter_file>
	</source>		</source>

2012-08-02T07:41:25Z

2012-05-02T14:19:01Z

← Nächstältere Version		Version vom 2. Mai 2012, 14:19 Uhr
Zeile 25:		Zeile 25:
	create or replace directory dump_dir as '/home/oracle/dumps';		create or replace directory dump_dir as '/home/oracle/dumps';
	</source>		</source>


	== Import ==		== Import ==
Zeile 52:		Zeile 51:
	REMAP_SCHEMA=<altes_Schema>:<neues_Schema>		REMAP_SCHEMA=<altes_Schema>:<neues_Schema>
	</source>		</source>



	== Einfach mal merken: ==		== Einfach mal merken: ==