hai, How to change oracle 10g server date without changing system date. Thank you... T Martin Andrews Did you know? You can CHAT without downloading...
There is no way to change the server date without change the system date... but may i know why you want to change the server date what is requirement is this? ...
sir, Just I ask sir. Because I am studying DBA sir. sir, I execute "alter system set fixed_date='12-oct-2008' " this query This query is changed oracle server...
Hello All, Â I have come across one error while dealing with sequences. Â I really did not get that error. Can anybody explain exactly what it specifies? ...
Thanks for the reply. But, when I alter as below: It gets altered. alter sequence s1_start increment by 3 --start with 24 minvalue 12 maxvalue 70 cycle Thanks ...
SQL> ! oerr ora 04013 04013, 00000, "number to CACHE must be less than one cycle" // *Cause: number to CACHE given is larger than values in a cycle // *Action:...
Thanks for thr reply Babu. I have this whole description & already raed it. But, wht my problem is , what exactly it specifies by this. Wht's the cache no...
hello, remove fixed_date parameter in your database. babu Martin Andrews <andrewstster@...> wrote: sir, I changed my oracle 10g server date using "alter...
Hello ,   I was asked like, an export of a table has taken place in one database of a schema called scott. And now I want to import that export dump file...
Raj, The import will fail with the error saying that the user or role does not exists. HTH, Karthick ________________________________ From: Rajasekhar Reddy...
But my manager says that the import will not fail , rather it'll happen with some warnings . Any update on this will be appreciated . Â Raj ... From: Karthick...
Hello All, Views: When we create a view, when exactly data gets stored in that view? Group Fn SUM: When we use sum() function, when exactly does the sum gets...
Hi Babu,   Thanks a ton, but this adds me one more small confusion . When the schema A , is dropped , and that dump file getting imported into B  schema...
Hello, Thanks a lot. NO; It's only DBA account not SYSDBA Babu Rajasekhar Reddy Anumula <rajreddydba@...> wrote: Hi Babu, Thanks a ton, but this adds...
Hi, I tried creating an undo tablespace in oracle 9i using the following command but the query did not respond for long time. The query that i ran is ...
Please post last 100 lines from alertlog. Babu guna dev <guna_dev@...> wrote: Hi, I tried creating an undo tablespace in oracle 9i using the following...
Thanks Babu. Here is the alert log. Also please find the alert log attached with this mail. Additional information: 3
Wed Nov 5 05:02:49 2008
Errors in file...
Oh. Sorry. I forgot to mention one point. I think undo tablespace already avaialble in your database. why your going to create again? Or U want to create new...
Yes i want to create new undo tablespace. I connected as sys. I already have one undo tablespace named UNDOTBS1. I just thought of creating another undo...
i think this is not the problem. you can create more than one undo tablespace. name should be diff. S. M. Monzur Hassan ... From: guna dev <guna_dev@...>...
Hi, Â Â Â Â u just create larger undo tablespace than last on and after that u drop the old one. Dont forget to modify the parameter file undo_tablespace=new...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
