WikiSysop: 1 revision imported

2016-03-25T08:51:03Z

1 revision imported

WikiSysop at 07:43, 19 June 2013

2013-06-19T07:43:14Z

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?

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:
<pre>
select original_name, object_name, droptime
from recyclebin
where
original_name = 'PS_NAMES'
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:
<pre>
flashback table tst to before drop
</pre>

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

http://springboardsolutions.com/errors_in_sql_plus.htm

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

Q: How do I find out when a database was refreshed?

Reply:

In Oracle, you determine when the database was created with:
<pre>
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:
<pre>
select trunc(audit_stamp),count(*) from psaudit group by trunc(audit_stamp) order by trunc(audit_stamp);
</pre>

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

← Older revision	Revision as of 08:51, 25 March 2016
(No difference)

PeopleSoft Questions - Revision history

WikiSysop: 1 revision imported

WikiSysop at 07:43, 19 June 2013