Hi,
I got stuck up when i was doing recovery. Please help me.
I opened the database in noarchivelog mode and inserted 5 records and made logswitch purposely but I dint gave any DML statements so that SYSTEM datafile gets affected. After that I shutdown the database and before starting the database I corrupted the datafile for which I inseted the records but I dint corrupt SYSTEM file.
After that when I tried to...
nkumarin001
Last Activity: Aug 22 '07, 05:11 PM
Joined: Jun 5 '07
Location:
-
Ora-00280..............
Hi,
I got stuck up when i was doing recovery. Please help me.
I took backup of all the datafiles,redog files and controlfiles.
I opened the database and created table called student. After that I inserted values to it and purposely made log switch. So that when alter database recover command is given it should prompt the archive log file.
insert into student values(101);
alter system switch logfile;... -
Run TKPROF..............
Hi,
My oracle version is 9.0.1.1.1
I am trying to run TKPROF utility.
In book i read that TKPROF utility is a stand-alone utility that is executed directly from the operating system prompt and should be executed from the directory where TKPROF is residing.
But when i tried to run it i got the following error:-
C:\oracle\ora90 \BIN>tkprof ORA02840.TRC traceEx.txt sys=yes;... -
Ora-16019...........
Hi,
First i like to thank all of you for helping me when i was in trouble.
Here i am with one more question.
I wanted to set 3 archive detination which is LOCAL, so i setted it using ALTER SYSTEM as follows:-
SQL> alter system set log_archive_des t='C:\oracle\ad min\Chandu\Arch ';
System altered.
SQL> sho parameter log_archive_des t;
NAME TYPE VALUE
------------------------------------------------------------------------... -
Hi,
Thank you for everyone to solve the problem. I got ORA-01092 error.
I created Pfile using following query:-
SQL> create pfile='C:\oracl e\admin\Chandu\ NewPfile.ora' from spfile;
File created.
After that i shutdown and tried to restart the instance but it gave ORA-01092 error:-
SQL> startup pfile='C:\oracl e\admin\Chandu\ pfile\NewPfile. ora';
ORACLE... -
Hi,
I came to know that i was using spfile by following query:-
SQL> select name,value from v$parameter where name='spfile';
NAME VALUE
--------- ----------------------------------------------
spfile %ORACLE_HOME%\D ATABASE\SPFILE% ORACLE_SID%.ORA
While i was browsing about spfile i came to know that the wrong thing i was doing is i was changing the value in...Leave a comment:
-
Ora-01092...................
Hi,
In book i read that "If you specify automatic undo management but provide no undo tablespace for oracle to use, oracle will not let your database start. So for example if you set UNDO_MANAGEMENT to AUTO but set UNDO_TABLESPACE to a tablespace that does not exist, then oracle will issue the ORA-01092 error when you attempt to start up nad open the database".
In init.ora i changed undo_tablespace... -
Ora-25143................
I have created two tablespaces:-
Tbsnav11 is correct
Tbsnav12 is wrong
First
SQL> create tablespace Tbsnav11
2 datafile 'C:\oracle\orad ata\Chandu\dbfn av11.dbf' size 3m
3 default storage
4 (
5 initial 10k
6 next 20k
7 pctincrease 50
8 );
Tablespace created.
SQL> select extent_manageme nt from dba_tablespaces... -
Ora-02097...................
Hi,
Sorry i had typed a wrong question previously so i dint know to edit it so i am writing one more question but this is different question,
I came to know that i am using spfile by following query:-
SQL> SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type"
2 FROM sys.v_$paramete r WHERE name = 'spfile';
Init F
------
SPFILE... -
Sort_Area_Size
Hi,
I am using pfile and i changed the value of Sort_Area_Size from 524288 to 1073741824(1GB) but when i started the database and checked the value of Sort_Area_Size it was showing 524288.
Please help me in this one to change the value of Sort_Area_Size from 524288 to 1073741824(1GB) and tell me why i was getting 524288 instead of 1073741824(1GB) .
Regards,
Naveen -
Bitmaps means Freelists
Hi,
Can anyone help me in this matter:-
When i was studying locally managed tablespaces i came across bitmaps that are used in locally managed tablespaces it stated that:-
"Locally managed tablespaces use bitmaps stored within the header of the datafiles comprising a tablespace to track the space utilization of the tablespaces."
AND
... -
Hi debasisdas
Thanks a lot its working fine. But i am confused why i got that error.
Regards,
Naveen...Leave a comment:
-
Hi Michael
Thanks a lot michael its working properly.
Regards
Naveen...Leave a comment:
-
CASE statement.........
Hi,
Can anyone please help me to rectify the problem.
Hi i wrote the following code regarding CASE statement:-
declare
num number :=45;
begin
case num
when num<20 then
dbms_output.put _line('Num is less then 20');
when num<40 then
dbms_output.put _line('Num is less then 40');
else
dbms_output.put _line('Num is less then 60');
end case;... -
Alter View.............
Hi,
Can any one please help me in this matter.
I have created a table :-
create table Employee
(
id number,
name varchar2(10),
city varchar2(10)
);
After that i created view for Employee table :-
create view viewEmployee
as
select * from Employee where id=101;
After that... -
Declare variable
Hi,
First i like to Thank all the users for helping me for clarifying my doubts,it has helped me a lot.
Here i am with one more question:-
In java if we want to decalre a variable and print that variable value we will do as below:-
int number=101;
System.out.prin tln(number);
But how we need to do that one in oracle?
Even... -
Hi sanora600,
Thanks for u r valuable answer it helped me a lot.
Regards,
Naveen...Leave a comment:
-
NULL values & UNIQUE Key
Hi,
I have some doubts regarding NULL values. Can any one help me in clearing my doubts.
I have created a table:-
create table suppliers
(
supplier_id number,
supplier_name varchar2(10)
);
Next, I will insert two records into this table.
insert into suppliers (supplier_id, supplier_name )
values ( 10565, null );
insert into suppliers... -
Segment.....
Hi,
Can anyone help me in this matter.
What is the difference between Table and Segment because i Eared table is nothing but a segment.
Regards,
Naveen -
temporary tablespace
Hi,
Sorry i typed a wrong question last time.
Please help me in this question.
1) Why we cant bring "temporary tablespace" offline?
2) Why we can bring "tempfile" offline?
Regards,
Naveen
No activity results to display
Leave a comment: