PeopleSoft Questions - Revision history

WikiSysop at 07:43, 19 June 2013

2013-06-19T07:43:14Z

← Older revision		Revision as of 07:43, 19 June 2013
Line 1:		Line 1:
-	Please add to this page any PeopleSoft Questions or queries you may have...	+	Please add to this page any [[PeopleSoft]] Questions or queries you may have...

	=================================================================================================		=================================================================================================

WikiSysop at 07:37, 19 June 2013

2013-06-19T07:37:53Z

← Older revision		Revision as of 07:37, 19 June 2013
Line 8:		Line 8:

	I suspect your issue here was that the table insert failed, but the script went on to drop the previous table anyway, so you ended up with a new empty table and the prior table was dropped. If you are running Oracle 10g or better, the table may exist in the database "recycle bin". Say for instance PS_NAMES is the affected table, we can find out if the dropped table is in the recycle bin:		I suspect your issue here was that the table insert failed, but the script went on to drop the previous table anyway, so you ended up with a new empty table and the prior table was dropped. If you are running Oracle 10g or better, the table may exist in the database "recycle bin". Say for instance PS_NAMES is the affected table, we can find out if the dropped table is in the recycle bin:
-		+	<pre>
	select original_name, object_name, droptime		select original_name, object_name, droptime
	from recyclebin		from recyclebin
Line 14:		Line 14:
	original_name = 'PS_NAMES'		original_name = 'PS_NAMES'
	order by drop time desc		order by drop time desc
		+	</pre>

	The object name from this query is the recycle bin name for the image of the dropped table (normally begins with "BIN$"). It can be selected as though it was a normal table so the rows can be checked. Once assured the table is there and is correct, it can be restored using:		The object name from this query is the recycle bin name for the image of the dropped table (normally begins with "BIN$"). It can be selected as though it was a normal table so the rows can be checked. Once assured the table is there and is correct, it can be restored using:
-		+	<pre>
	flashback table tst to before drop		flashback table tst to before drop
		+	</pre>

	Now we can look at prevention, rather than cure - see this article:		Now we can look at prevention, rather than cure - see this article:
Line 31:		Line 33:

	In Oracle, you determine when the database was created with:		In Oracle, you determine when the database was created with:
-		+	<pre>
	select name,created from v$database;		select name,created from v$database;
		+	</pre>

	Not a perfect method, but the last day the database was Production will be the last day there was a large amount of activity:		Not a perfect method, but the last day the database was Production will be the last day there was a large amount of activity:
-		+	<pre>
	select trunc(audit_stamp),count(*) from psaudit group by trunc(audit_stamp) order by trunc(audit_stamp);		select trunc(audit_stamp),count(*) from psaudit group by trunc(audit_stamp) order by trunc(audit_stamp);
		+	</pre>

	=================================================================================================		=================================================================================================

WikiSysop at 07:31, 19 June 2013

2013-06-19T07:31:32Z

← Older revision		Revision as of 07:31, 19 June 2013
Line 19:		Line 19:
	flashback table tst to before drop		flashback table tst to before drop

-	Now we can look at prevention, rather than cure:	+	Now we can look at prevention, rather than cure - see this article:
-		+
-		+

		+	http://springboardsolutions.com/errors_in_sql_plus.htm


Line 30:		Line 29:

	Reply:		Reply:
		+
	In Oracle, you determine when the database was created with:		In Oracle, you determine when the database was created with:

WikiSysop at 07:27, 19 June 2013

2013-06-19T07:27:10Z

← Older revision		Revision as of 07:27, 19 June 2013
Line 6:		Line 6:

	Reply:		Reply:
		+
		+	I suspect your issue here was that the table insert failed, but the script went on to drop the previous table anyway, so you ended up with a new empty table and the prior table was dropped. If you are running Oracle 10g or better, the table may exist in the database "recycle bin". Say for instance PS_NAMES is the affected table, we can find out if the dropped table is in the recycle bin:
		+
		+	select original_name, object_name, droptime
		+	from recyclebin
		+	where
		+	original_name = 'PS_NAMES'
		+	order by drop time desc
		+
		+	The object name from this query is the recycle bin name for the image of the dropped table (normally begins with "BIN$"). It can be selected as though it was a normal table so the rows can be checked. Once assured the table is there and is correct, it can be restored using:
		+
		+	flashback table tst to before drop
		+
		+	Now we can look at prevention, rather than cure:
		+
		+
		+
		+

	=================================================================================================		=================================================================================================

WikiSysop: /* = */

2013-06-02T15:35:04Z

← Older revision		Revision as of 15:35, 2 June 2013
Line 18:		Line 18:
	Not a perfect method, but the last day the database was Production will be the last day there was a large amount of activity:		Not a perfect method, but the last day the database was Production will be the last day there was a large amount of activity:

-	select trunc(audit_stamp),count(*) from psaudit group by trunc(audit_stamp);	+	select trunc(audit_stamp),count(*) from psaudit group by trunc(audit_stamp) order by trunc(audit_stamp);
-		+
	=================================================================================================		=================================================================================================

WikiSysop at 20:24, 22 May 2011

2011-05-22T20:24:20Z

← Older revision		Revision as of 20:24, 22 May 2011
Line 4:		Line 4:

	Q: Ran a SQL script from app des build, insert failed, how can I stop this happening?		Q: Ran a SQL script from app des build, insert failed, how can I stop this happening?
		+
	Reply:		Reply:

Line 9:		Line 10:

	Q: How do I find out when a database was refreshed?		Q: How do I find out when a database was refreshed?
		+
	Reply:		Reply:
	In Oracle, you determine when the database was created with:		In Oracle, you determine when the database was created with:

WikiSysop at 22:22, 2 March 2011

2011-03-02T22:22:28Z

← Older revision		Revision as of 22:22, 2 March 2011
Line 8:		Line 8:
	=================================================================================================		=================================================================================================

-	Q:	+	Q: How do I find out when a database was refreshed?
	Reply:		Reply:
		+	In Oracle, you determine when the database was created with:
		+
		+	select name,created from v$database;
		+
		+	Not a perfect method, but the last day the database was Production will be the last day there was a large amount of activity:
		+
		+	select trunc(audit_stamp),count(*) from psaudit group by trunc(audit_stamp);
		+
	=================================================================================================		=================================================================================================

WikiSysop at 11:34, 26 February 2011

2011-02-26T11:34:31Z

← Older revision		Revision as of 11:34, 26 February 2011
Line 4:		Line 4:

	Q: Ran a SQL script from app des build, insert failed, how can I stop this happening?		Q: Ran a SQL script from app des build, insert failed, how can I stop this happening?
		+	Reply:

	=================================================================================================		=================================================================================================

	Q:		Q:
-		+	Reply:
	=================================================================================================		=================================================================================================

WikiSysop: Created page with "Please add to this page any PeopleSoft Questions or queries you may have... ================================================================================================= Q:..."

2011-01-26T21:27:04Z

Created page with "Please add to this page any PeopleSoft Questions or queries you may have... ================================================================================================= Q:..."

New page

Please add to this page any PeopleSoft Questions or queries you may have...

=================================================================================================

Q: Ran a SQL script from app des build, insert failed, how can I stop this happening?

=================================================================================================

Q:

=================================================================================================