PeopleSoft Questions

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:

select original_name, object_name, droptime

select original_name, object_name, droptime

from recyclebin  

from recyclebin  

original_name = 'PS_NAMES'

original_name = 'PS_NAMES'

order by drop time desc

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:

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

flashback table tst to before drop

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

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

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

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

select name,created from v$database;

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:

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) order by trunc(audit_stamp);

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

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

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