|
All in One -
Data
|
|
Written by Administrator
|
|
Thursday, 23 July 2009 08:14 |
|
ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=h:\oradata\archive' SCOPE=BOTH;
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST
Solution :
1. Reset the LOG_ARCHIVE_DEST to NULL value :
SQL> ALTER SYSTEM set log_archive_dest='';
2. Set the LOG_ARCHIVE_DEST_1 to the value set to LOG_ARCHIVE_DEST before
SQL> ALTER SYSTEM set log_archive_dest_1='LOCATION=/...';
if you use this code, you dont need to restart database:
ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=h:\oradata\archive' SCOPE=BOTH;
To check archival destination issue is ok: show parameter LOG_ARCHIVE_DEST;
select DEST_ID, DEST_NAME,DESTINATION from v$archive_dest;
|
|
Last Updated ( Thursday, 23 July 2009 08:29 )
|
|
|
All in One -
Data
|
|
Written by Administrator
|
|
Friday, 26 June 2009 08:32 |
|
solution : extend size of temp tablespace |
|
Last Updated ( Friday, 26 June 2009 08:34 )
|
|
All in One -
Data
|
|
Written by Administrator
|
|
Friday, 15 May 2009 15:08 |
|
Saving changes is not permitted.The changes you have made require the following tables to be dropped and re-created.You have either made changes to a table that can't be re-create or enabled the option Prevent saving changes that require the table to be re-created. Go to Tools --> Options --> Designer uncheck "Prevent saving changes that require table re-creation" |
|
Last Updated ( Friday, 15 May 2009 20:13 )
|
|
All in One -
Data
|
|
Written by Administrator
|
|
Tuesday, 31 March 2009 08:23 |
|
Example Number 1 ...
create sequence product_seq start with 1 increment 1
/
create or replace trigger product_insert before insert for each row begin
select productseq.nextval
into :new.product_id
from dual;
end;
/
Example Number 2 ... How to create an autoincrement field in a table with a sequence ...
SQLWKS> create table bob(a number , b varchar2(21));
Statement processed.
First create a sequence
SQLWKS> create sequence x ;
Statement processed.
Then create the trigger.
create trigger y before insert on bob
for each row
when (new.a is null)
begin
select x.nextval into :new.a from dual;
end;
/
Example Number 3 ...
First create a sequence:
create sequence emp_no_seq;
By default it increments by 1 starting at 0.
Use its values when inserting data into the table:
insert into t_emp values (emp_no_seq.nexval, 'Joe Black'); |
|
Last Updated ( Friday, 15 May 2009 20:14 )
|
|
|
|
|
Page 2 of 2 |
