<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0"
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:wfw="http://wellformedweb.org/CommentAPI/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
	xmlns:atom="http://www.w3.org/2005/Atom"
	xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
	xmlns:slash="http://purl.org/rss/1.0/modules/slash/"
	>

<channel>
	<title>Różności ... &#187; Oracle</title>
	<atom:link href="http://www.jaceksen.pl/wordpress/?cat=6&#038;feed=rss2" rel="self" type="application/rss+xml" />
	<link>http://www.jaceksen.pl/wordpress</link>
	<description>czyli moje notki</description>
	<lastBuildDate>Sun, 14 Nov 2021 16:21:49 +0000</lastBuildDate>
	<language>en</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
	<generator>http://wordpress.org/?v=3.0.3</generator>
		<item>
		<title>Rollback</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4472</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4472#comments</comments>
		<pubDate>Tue, 19 Apr 2016 08:08:30 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Oracle]]></category>
		<category><![CDATA[database]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4472</guid>
		<description><![CDATA[What will happen to rollback session if database shutdown immediate/abort? Na to pytanie udzielono już odpowiedzi. bk75 2009-11-28 15:58 I have a long running rollback session after i killed it. The status of session is &#8216;KILLED&#8217; and when I check the v$transaction, it will take almost 24hours to complete rollback. We cannot wait for so [...]]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4472</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>oracle em agent unreachable</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4440</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4440#comments</comments>
		<pubDate>Fri, 11 Dec 2015 17:20:56 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Oracle]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4440</guid>
		<description><![CDATA[&#8211; To implement the solution, please execute the following steps:: 1. Stop the agent 2. Remove all the files from AGENT_HOME/sysman/log/ directory. 3. Backup and edit AGENT_HOME/sysman/config/emd.properties. 4. Add this line: NMUPM_TIMEOUT=120 5. Uncomment: ThreadPoolModel = LARGE 6. start the agent 7. Monitor the performance of the server https://community.oracle.com/message/2558818#2558818]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4440</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>report schema</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4438</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4438#comments</comments>
		<pubDate>Thu, 10 Dec 2015 20:25:11 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Oracle]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4438</guid>
		<description><![CDATA[http://www.dba-oracle.com/t_rman_46_schema_report.htm]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4438</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>srvctl</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4436</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4436#comments</comments>
		<pubDate>Wed, 09 Dec 2015 20:59:40 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Oracle]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4436</guid>
		<description><![CDATA[https://oracleexamples.wordpress.com/2010/01/22/most-used-srvctl-commands/ What is srvctl? it is the Server Control Utility, we use SRVCTL to start and stop the database and instances, manage configuration information, and to add, move or remove instances and services. These are some of the srvctl commands I frequently use, this is not a complete reference guide. I organized the commands as [...]]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4436</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>grant select on all tables</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4341</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4341#comments</comments>
		<pubDate>Thu, 11 Dec 2014 15:58:52 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Bazy danych]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4341</guid>
		<description><![CDATA[You could, of course, leverage dynamic SQL, i.e. FOR x IN (SELECT * FROM user_tables) LOOP   EXECUTE IMMEDIATE 'GRANT SELECT ON ' &#124;&#124; x.table_name &#124;&#124; ' TO &#60;&#60;someone&#62;&#62;'; END LOOP; Of course, if you&#8217;re doing this sort of thing, you&#8217;d normally grant the privileges to a role and grant that role to one or [...]]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4341</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Error Opening RPD Online: [nQSError: 46036] Internal Assertion</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4319</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4319#comments</comments>
		<pubDate>Sat, 22 Nov 2014 12:12:52 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Bazy danych]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4319</guid>
		<description><![CDATA[http://bidirect.blogspot.com/2013/07/error-opening-rpd-online-nqserror-46036.html]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4319</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Oracle BI</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4306</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4306#comments</comments>
		<pubDate>Thu, 06 Nov 2014 09:18:56 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Oracle]]></category>
		<category><![CDATA[BI]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4306</guid>
		<description><![CDATA[http://www.oracle.com/us/solutions/business-analytics/business-intelligence/overview/index.html http://www.oracle.com/technetwork/middleware/bi-foundation/overview/index.html?ssSourceSiteId=ocomen]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4306</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>ora-00604 timezone region not found sql developer</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4281</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4281#comments</comments>
		<pubDate>Fri, 10 Oct 2014 06:06:17 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Bazy danych]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4281</guid>
		<description><![CDATA[check timezone in your database add following entry do sqldeveloper.conf with appropriate timezone name AddVMOption -Duser.timezone=America/Santiago restart sqldeveloper VOILA!]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4281</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>APEX upgrade</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4253</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4253#comments</comments>
		<pubDate>Mon, 11 Aug 2014 12:20:03 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[ApEx]]></category>
		<category><![CDATA[Bazy danych]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[Programowanie]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4253</guid>
		<description><![CDATA[http://infotechinspiration.blogspot.com/2010/07/upgrade-oracle-apex-40-in-11g-database.html]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4253</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>datapump expdp impdp</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4247</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4247#comments</comments>
		<pubDate>Mon, 21 Jul 2014 08:33:52 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Bazy danych]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4247</guid>
		<description><![CDATA[CONN / AS SYSDBA ALTER USER scott IDENTIFIED BY tiger ACCOUNT UNLOCK; CREATE OR REPLACE DIRECTORY test_dir AS &#8216;/u01/app/oracle/oradata/&#8217;; GRANT READ, WRITE ON DIRECTORY test_dir TO scott; expdp scott/tiger@db10g tables=EMP,DEPT directory=TEST_DIR dumpfile=EMP_DEPT.dmp logfile=expdpEMP_DEPT.log impdp hr/HR directory=DATADUMP dumpfile=FMC_LOGICAL_VESSELS.DMP remap_schema=VTRACK:HR exclude=index,constraint,grant,trigger expdp user/pass schemas= directory=dumpdir \ dumpfile=.dmp \ logfile=expdp_.log impdp user/pass schemas=schema1 directory=dumpdir \ remap_schema=schema1:schema2 \ dumpfile=schema1.dmp [...]]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4247</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>table to csv</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4244</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4244#comments</comments>
		<pubDate>Thu, 17 Jul 2014 17:19:19 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Bazy danych]]></category>
		<category><![CDATA[Linux]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4244</guid>
		<description><![CDATA[#!/usr/bin/bash FILE=&#8221;emp.csv&#8221; sqlplus -s scott/tiger@XE Setting the column separator to &#8220;,&#8221;. With this setting, the list displayed by the SELECT clause will be comma separated. This is the most important setting of this script. SET LINESIZE 200 => The number of characters per line. The default is 80 which means after 80 characters, the rest [...]]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4244</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Oracle on Solaris 10 : Fixing the &#8216;ORA-27102: out of memory&#8217; Error</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4202</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4202#comments</comments>
		<pubDate>Mon, 02 Jun 2014 20:12:40 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Bazy danych]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[Solaris]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4202</guid>
		<description><![CDATA[https://blogs.oracle.com/mandalika/entry/oracle_on_solaris_10_fixing]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4202</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>ASM</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4193</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4193#comments</comments>
		<pubDate>Mon, 02 Jun 2014 16:48:42 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Bazy danych]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4193</guid>
		<description><![CDATA[http://blog.sina.com.cn/s/blog_4ea0bbed0100zd6d.html http://docs.oracle.com/cd/E11882_01/server.112/e18951/asmdiskgrps.htm#OSTMG94156]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4193</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>joins</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4044</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4044#comments</comments>
		<pubDate>Mon, 17 Feb 2014 05:30:08 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Bazy danych]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[Programowanie]]></category>
		<category><![CDATA[SQL]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4044</guid>
		<description><![CDATA[NATURAL JOIN INNER JOINS SELECT employee_id, last_name, department_name FROM hr.employees JOIN hr.departments USING (department_id) ; SELECT l.city, d.department_name FROM locations l JOIN departments d USING (location_id) WHERE location_id = 1400; SELF JOIN Sometimes you need to join a table to itself. To find the name of each employee’s manager, you need to join the EMPLOYEES [...]]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4044</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>ORACLE &#8211; archive log mode.</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4008</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4008#comments</comments>
		<pubDate>Wed, 22 Jan 2014 19:49:22 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Bazy danych]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4008</guid>
		<description><![CDATA[SQL&#62; startup mount ORACLE instance started. Total System Global Area 184549376 bytes Fixed Size 1300928 bytes Variable Size 157820480 bytes Database Buffers 25165824 bytes Redo Buffers 262144 bytes Database mounted. SQL&#62; alter database archivelog; Database altered.]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4008</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>ORACLE &#8211; Renaming and moving files.</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4006</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4006#comments</comments>
		<pubDate>Wed, 22 Jan 2014 08:15:55 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Bazy danych]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4006</guid>
		<description><![CDATA[http://www.oracle-base.com/articles/misc/renaming-or-moving-oracle-files.php]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4006</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Oracle 11g installation on Centos 6.4</title>
		<link>http://www.jaceksen.pl/wordpress/?p=3888</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=3888#comments</comments>
		<pubDate>Thu, 14 Nov 2013 08:55:09 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Bazy danych]]></category>
		<category><![CDATA[Linux]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=3888</guid>
		<description><![CDATA[http://www.tecmint.com/oracle-database-11g-release-2-installation-in-linux/]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=3888</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Kolejność działań</title>
		<link>http://www.jaceksen.pl/wordpress/?p=3762</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=3762#comments</comments>
		<pubDate>Thu, 25 Apr 2013 06:50:08 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Oracle]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=3762</guid>
		<description><![CDATA[]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=3762</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Oracle Enterprise Manager in Linux.</title>
		<link>http://www.jaceksen.pl/wordpress/?p=3704</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=3704#comments</comments>
		<pubDate>Sat, 24 Nov 2012 21:15:46 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Bazy danych]]></category>
		<category><![CDATA[Linux]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=3704</guid>
		<description><![CDATA[emctl start dbconsole emctl status agent emctl stop agent https://host:1158/em/console/aboutApplication]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=3704</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>ORA-00845: MEMORY_TARGET not supported on this system</title>
		<link>http://www.jaceksen.pl/wordpress/?p=3700</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=3700#comments</comments>
		<pubDate>Sat, 24 Nov 2012 20:52:04 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Bazy danych]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=3700</guid>
		<description><![CDATA[Problem Description While creating a startup database using dbca the database creation GUI gives error message in a pop up window, ORA-00845: MEMORY_TARGET not supported on this system from where you can ignore the error message. The similar scenario also occur whenever you try to start your database then startup shows error message like below. [...]]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=3700</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
	</channel>
</rss>
