RE:[sap-basis] No contents in DBA_TEMP_FILES
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by Snowy (Certified Netweaver '04/Oracle Basis consultant) on May 3 at 1:30 PM |  Mark as helpful |
Hi, check backup controlfile trace file. you probably forgot to add PSAPTEMP datafiles.
---------------Original Message---------------
From: JHandersen
Sent: Tuesday, June 12, 2007 10:25 AM
Subject: No contents in DBA_TEMP_FILES
> Hi
>
> After system copy from Prod to Q. I found that tablespace PSAPTEMP is empty then I added datafiles to it using alter command taking the size to 2gb but when I'm using db02--> current sizes--> datafiles/tempfiles I'm unable to see here the files which I have added to the tablespace although I can see those datafiles from database level
>
> what could be the problem
>
> Regards
> J.Handersen
__.____._ ---------------Original Message---------------
From: JHandersen
Sent: Tuesday, June 12, 2007 10:25 AM
Subject: No contents in DBA_TEMP_FILES
> Hi
>
> After system copy from Prod to Q. I found that tablespace PSAPTEMP is empty then I added datafiles to it using alter command taking the size to 2gb but when I'm using db02--> current sizes--> datafiles/tempfiles I'm unable to see here the files which I have added to the tablespace although I can see those datafiles from database level
>
> what could be the problem
>
> Regards
> J.Handersen
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
SnowySAP Basis Helper
Posted helpful replies on 50 threads in a group to earn a Silver Achievement
In the Spotlight
Your SAP Security is at Risk...Learn How to Stay Protected. Read the free white paper from SenSage
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
_.____.__ 
