Hi friends
wish u all a very happy new year
i am getting the following error when i run my report
REP-1219: 'Object name' has no size -- length or width is zero.
but when i rebuild the report again it works well
but when i save it and run it next time it again gives the same error
and i have
OK folks I'm out on the dark side, once again. Does anyone remember how MicroSlop's
BCP utility in SQL*server works? I've got a user who bought a third party SQL*server
application, I won't go there, and he needs to move some data from a desktop to a
laptop SQL*server database.
Dick Goulet
Sure; bcp is pretty straightforward. It can handle all sorts
of formats on the data file (much more flexible than exp/imp
or sql*loader in my experience)
I maintain a sybase dba page here:
www.bossconsulting.com/sybase_dba
Click on my personal faq link then scroll down to the
bcp specific
Not sure what you're asking here, but SQL Server Books Online (search on
bcp Utility) should give you that information.
-Original Message-
Sent: Friday, October 31, 2003 11:10 AM
To: Multiple recipients of list ORACLE-L
OK folks I'm out on the dark side, once again. Does anyone
you need to create a format file (.fmt) for the that as per your data file.
-Original Message-
Goulet, Dick
Sent: Friday, October 31, 2003 9:40 PM
To: Multiple recipients of list ORACLE-L
OK folks I'm out on the dark side, once again. Does anyone remember how
MicroSlop's BCP utility in
Thanks all for the help. As with many things, UnSubstantiated Error Reporters (USERS)
tell you one thing when they mean another. In this case it wasn't SQL*server, but
MSDE that was in use. Got a script off of MicroSlop's site that explained what to do.
Damned messy, hope it works!! :-(
Title: RE: OT: Need help with SQL*Server
Not only BCP..
Create a DTS package to suck it in.. It will allow you to do source to target mapping.. Copy the file over, and have them use the facility to map and import the data via the GUI.
Just an alternative to the good old BCP..
Greg
Hi. I have a query that seems to be waiting for a PS
enqueu for about 2 days. When querying the
v$session_wait, I'm getting the following:
SID EVENT S-I-WT P1
P2 P3
- - -- --
--- --
48
I plan to select distinct data from table. anyone has
suggestion?
Thanks.
select distinct employee
from (select employee_id, lname, fname, mi, hiredate
, as employee from emp)
SQL
SQL /
from (select employee_id, lname, fname, mi, hiredate ,
as employee from emp)
Title: RE: [Q] need help on SQLplus select distinct !!
shouldn't that be
select distinct employee_id
from emp
/
??
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email
You got an extra comma in your statement.
Btw, check your statement construction, you probably want the subquery named
as employee not hiredate column..
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, September 23, 2003 5:59 PM
I
Mike,
You really don't need to in-line view for this. I'm also not sure what
exactly you are trying to do.
You could:
select distinct employee_id, lname, fname, mi, hiredate
from emp
or
select distinct employee_id from emp
what exactly are your trying to get? Distinct employee_id's?
Are you doing homework...?
Shame on you
-Original Message-
Sent: Tuesday, September 23, 2003 10:00 AM
To: Multiple recipients of list ORACLE-L
I plan to select distinct data from table. anyone has
suggestion?
Thanks.
select distinct employee
from (select employee_id, lname,
Select distinct employee_id||lname|fname|mi||hiredate as employee from emp
-Original Message-
Sent: Tuesday, September 23, 2003 5:00 PM
To: Multiple recipients of list ORACLE-L
I plan to select distinct data from table. anyone has suggestion?
Thanks.
select distinct employee
sorry about that, but if you don't want answer, you can easy to ignore. You don't need insult other people. You may good, but everyone sometime still need start from fresh.
"Odland, Brad" [EMAIL PROTECTED] wrote:
Are you doing homework...?Shame on you-Original Message-Sent: Tuesday,
but just ignoring message is NOT what this list is all about.
Joe
mike mon wrote:
sorry about that, but if you don't want answer, you can easy to
ignore. You don't need insult other people. You may good, but
everyone sometime still need start from fresh.
*/Odland, Brad [EMAIL
select distinct column1, columnn2 , ...
from table;
Stephane
-Original Message-
mike mon
Sent: Tuesday, September 23, 2003 11:00 AM
To: Multiple recipients of list ORACLE-L
I plan to select distinct data from table. anyone has
suggestion?
Thanks.
select distinct employee
Guru:
I need help with an error ORA-12640.
I have a Oracle 8.1.7 database with 8.1.7.4 patch running on Windows 2000.
The sqlnet.authentication_services=(NTS) parameter is enabled and we do
not want to change the sqlnet.authentication_services=(NONE).
The custom SQL application
changes too most likely
cannot connect too.
If is not ONS then you can reference your client machine setting.
hope this can help you, good luck
Sinardy
-Original Message-
Sent: 28 August 2003 14:19
To: Multiple recipients of list ORACLE-L
Guru:
I need help with an error ORA-12640
How does the application connect to the database?
username/password or '/'?
Jared
On Wed, 2003-08-27 at 23:19, Lee, Peter (AZ15) wrote:
Guru:
I need help with an error ORA-12640.
I have a Oracle 8.1.7 database with 8.1.7.4 patch running on Windows 2000
) wrote:
Guru:
I need help with an error ORA-12640.
I have a Oracle 8.1.7 database with 8.1.7.4 patch running on Windows
2000.
The sqlnet.authentication_services=(NTS) parameter is enabled and we do
not want to change the sqlnet.authentication_services=(NONE).
The custom SQL
Im calling a script that uses dynamic sql. Im passing in a value as well. I keep
getting
SP2-0552: Bind variable 2 not declared.
Here is a code snipped
declare
v_var1 Varchar2(30) := 'TEST';
v_var2 VARCHAR2(30) := '1';
total number;
begin
execute immediate ' Select * ' ||
Your using v_var1,v_var2 shouldn't be appended to the
string that represents the dynamic SQL to execute;
the using... is part of the syntac for execute immediate.
An Oracle error message being what they are, they don't
always highlight the correct cause of fault, but will
identify some other error
that was just a mock up of what I wrote. I dont have '||' in the real
version. Its jut a typo here. Anyone know what is going on?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, July 21, 2003 5:24 PM
Your using v_var1,v_var2 shouldn't be
Hi,
I have two tables
1. ALL_CUSTOMER
CustNo: 1 to 100
OtherDetail: bla bla bla
2. ORDER
CustNo
TotalOrder
DateOrder
I want to display like this
CustomerNo 1Total Order For This month = 101
or
CustomerNo 1 Total Order For This month = 0
My SQL statement is
select 'CustomerNo '||a.custno||' Total Order for this month =
'||nvl(c.totalorder,0)
from
all_customer a,
(SELECT b.custno as custno, sum(b.totalorder) as totalorder
from orders b
group by b.custno,to_char(b.dateorder,'mm')
having
Outer join?
Guang
On Thu, 3 Jul 2003, Sinardy Xing wrote:
Hi,
I have two tables
1. ALL_CUSTOMER
CustNo: 1 to 100
OtherDetail: bla bla bla
2. ORDER
CustNo
TotalOrder
DateOrder
I want to display like this
CustomerNo 1Total Order For This month = 101
Hi
all,
Can
anyone tell me which of the following performs better in collecting statistics
of a table:
Analyze
command or
Dbms_stats.gather_table_stats
I tried my queries with
both the options -- but always Analyze is out-performing the
dbms_stats.
But i read in a
document that
Kesh - What do you define as performance?
1. How fast a table is analyzed?
2. The performance of the queries that use the statistics that were
collected?
What Oracle version are you on?
In theory, you can analyze tables when the system load isn't so great. In 9i
you can even have Oracle decide
, and validating the structure.
Djordje
-Original Message-From: Jayaram Keshava Murthy
(Cognizant) [mailto:[EMAIL PROTECTED]Sent: Monday, June
02, 2003 10:50 AMTo: Multiple recipients of list
ORACLE-LSubject: Need help
Hi
all,
Can
anyone tell me which of the following
: Need help
I have done some test before and found out that analyze is faster than dbms_stats
for smaller tables only (less than 10M) - and the difference was not that big (for
example very small tables dbms_stats would do a compute instead of estimate). For
large tables they are pretty much
Yes, I am talkin about the time it takes. The analyze command takes around 2 mins to
esimate statistics of a table with a Million records whereas the dbms_stats package
function is merely hanging !!
And besides, Djordje is telling that they nearly take up the same time !! But i am
not
(Cognizant) [mailto:[EMAIL PROTECTED]]
Sent: Monday, June02, 2003 10:50 AM
To: Multiple recipients of listORACLE-L
Subject: Need help
Hi
all,
Cananyone tell me which of the following performs better in collecting
statisticsof a table
Saturday, May 31, 2003, 2:44:41 AM, you wrote:
RD Simply go to
RD http://testprep.selftestsoftware.com/W4RT052EB6F8A396076E3EEF0024
RD and your discount will automatically show on all individually
RD packaged products on the site.
I looked at this. Their regular price is $99.00. As I
recall,
Hi Group,
I wanted to do 9i OCP. Any good sites are there to give free sample exam
questions. (I want a full set not that 12 Question exams).
Expecting ur help.
Thanx For All,
Senthil.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Senthil Kumar D
INET: [EMAIL
Senthil
I hope you get a reply. But I have searched for the same and I don't
think anyone will go to the trouble of creating a really good exam, then
giving it away for free. As we discussed yesterday on this list, Couchman is
a good author to use, and even he has a few glitches. But when you
Dennis,
You are right. Nothing is free if t has a quality. Best option is to buy sts
question which cosr normally $99 but they also offer sometimes at 25-30%
discount. Alternately buy Daniels 9i new features comes with test question
CD. I rather suggest Senthil to buy sts eaxm questions and
Hi All,
They are at the moment offering 50% discount...
Here is an excerpt from one recent promotion..
SAVE 50% on all individually packaged Self Test Software test
prep products from 12:01 am, May 28, 2003 to midnight EDT on
May 31, 2003.
There will be no backdating or extensions on
Title: RE: need help with dynamic sql
if you at-least know the source and destination tables will have same number of columns and data types ... you could just do something like
insert into target.table
select from source.table
Raj
Not with execute immediate. Use dbms_sql
I have done this.
For example and help
http://asktom.oracle.com/pls/ask/f?p=4950:8:104566430235951855::NO::F495
0_P8_DISPLAYID,F4950_P8_CRITERIA:584023239495,
Regards,
Kamaljeet Singh (NCDB ASG)
MBT, 52 Barrack Square, Martlesham. IP5 3RF.
Off. 01473
the comma delimited string of columns.
From: Jamadagni, Rajendra [EMAIL PROTECTED]
Date: 2003/03/11 Tue AM 11:29:03 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: need help with dynamic sql
if you at-least know the source and destination tables will have same number
This probably isnt that hard, but Im having a brain dead moment.
My goal is to select data from a table in one schema and insert it into the same table
in another schema. However, I am not 100% certain that the tables exist in both
schemas or that the columns are the same.
The columns can be
Title: RE: Need help with a dynamic query
Since the target schema is the one whose columns matter most, I would think that you should do an outer join to the columns in the original schema, to see if any not null columns in the target schema are missing from the original schema
SELECT
'CREATE TABLE TMP_'||table_name||' TABLESPACE tables AS '||chr(10)||
'SELECT * FROM '||table_name||';'
from sys.all_tables where owner = 'yourowner';
Or add a @dblink
bob
This probably isnt that hard, but Im having a brain dead moment.
My goal is to select data from a table
Hi
Gurus
I am not a DBA,
but I have request from client to move their oracle 8.1.6 database from a
Unix server to W2K. Can somebody lead me to documentation in moving entire DB or
any other resource that will help me accomplish the task?
Thanks a ton in
advance
Regards
Shiva
, Shiva
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 29, 2003 12:59
PMTo: Multiple recipients of list ORACLE-LSubject: Need
help and documentation on moving database from Unix to
W2K
Hi
Gurus
I am not a DBA,
but I have request from client to move their oracle 8.1.6 database
Why do they want to move to W2k? Was it running too quickly for them under Unix? ;^)
You can use export/import to move the database. Hopefully the database isn't very big.
--
Alan Davey
[EMAIL PROTECTED]
212-604-0200 x106
On 1/29/2003 12:59 PM, Baswannappa, Shiva [EMAIL PROTECTED] wrote:
Shiva
First I would suggest you consider whether this is a good use of your
client's money. This is a somewhat complex task that will be a good learning
experience for you personally, but may cost the client. You should also
consider how you will be able to confirm the quality of your work
Thanks everybody
I have performed it on a smaller test machine and will do the production
database import/export tonight.
Regards
Shiva
-Original Message-
Sent: Wednesday, January 29, 2003 2:00 PM
To: Multiple recipients of list ORACLE-L
W
Shiva
First I would suggest you consider
Of SergeiSent: Wednesday,
December 11, 2002 6:59 PMTo: Multiple recipients of list
ORACLE-LSubject: Need help Reformatting output
I am looking for a way to
display rows as columns.
For
example:
Id
name
value
1
a
5
1
b
10
2
a
15
2
b
20
I need
:
Sergei
To: Multiple recipients of list ORACLE-L
Sent: Thursday, December 12, 2002 4:59
AM
Subject: Need help Reformatting
output
I am looking for a way to
display rows as columns.
For
example:
Id
name
value
1
a
5
1
b
10
2
a
15
2
b
'). The chapter is entitled 'DECODE - Amazing Power in a Single Word'.
peter
edinburgh
-Original Message-From: Sergei
[mailto:[EMAIL PROTECTED]]Sent: 12 December 2002
02:59To: Multiple recipients of list ORACLE-LSubject:
Need help Reformatting output
I am looking for a way
recipients of list ORACLE-L
Sent: Thursday, December 12, 2002 10:38
AM
Subject: Re: Need help Reformatting
output
You can try concatenation.
Pseudo code:
c1 := null
c2 := null
c3 := null
open cursor
while not end-of-set
c1 := id || ' '
c2 := name || ' '
c3 := vale
Hi
Is this in a report if so i can help you else aim sorry.
thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Walid Alkaakati
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California--
It is an on line report. The client will enter the number of IDs, and I
will have to construct a query so the output will be
FROM
Id namevalue
1 a 5
1 b 10
2 a 15
2 b 20
THIS
name1
Title: RE: Active sessions chewing up a huge amount of RAM
I am looking for a way to display rows as columns.
For example:
Id name value
1 a 5
1 b 10
2 a 15
2 b 20
I need it as:
name 1 2
a
5 15
b 10 20
Thank you in advance
Sergei.
]
cc:
Subject:RE: Need Help on Operational Data Store
Jared
And just think, if you'd given it a snappy name like ODS, you'd be
jetting around to big conventions and big corporate clients, hosting the
greatest technical advice line on the Internet . . . oh, wait you already
do
to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Need Help on Operational Data Store
Jared
Oh, I wouldn't let Bill Inmon hear you say that. He coined the term
Operational Data Store. I do not purport to be a data
Greetings -
I need some help with building an Operational Data Store. I know there are
a lot of confusion in ODS vs. DW but I belong to the camp of 'ODS should be
used only for operational reporting, not decision support'. So while
Kimball talks a lot about building a DW in his books, he does not
Dennis - Bill Inmon is the patron saint of the ODS people. Pretty much equal
industry status with Ralph. Claims the title of The Father of Data
Warehousing (right there on his site). Start with his Web site at
http://www.billinmon.com/. His articles are published on DB Review magazine,
Dennis,
I think you got it wrong right off when you stated that there's a
lot of confusion in ODS vs. DW .
It isn't that issue at all. No two people can agree on what an ODS
is at all, much less compare it to a DW.
To me for instance, an ODS is a place to stage data for the final
stages of
Jared
Oh, I wouldn't let Bill Inmon hear you say that. He coined the term
Operational Data Store. I do not purport to be a data warehouse expert at
the least, but several years ago I studied the literature quite a bit and
tried to keep on top of the topics. And the subject has evolved some
:
Sent by: Subject: Re: Need Help on Operational
Data Store
[EMAIL PROTECTED
a lot of energy in designing, though we didn't call it an ODS.
Jared
DENNIS WILLIAMS [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/08/2002 11:24 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Need
. To: Multiple recipients
of list ORACLE-L [EMAIL PROTECTED]
com cc:
Sent by: Subject: Re: Need Help on
Operational Data Store
em", not a simple
"reporting database copy") is a better solution for all of them...
Hope this helps...
-Tim
- Original Message -
From: [EMAIL PROTECTED]
To: "Multiple recipients of list ORACLE-L"
[EMAIL PROTECTED]
Sent: Friday, November 08, 2002 12:43
PM
Subject:
@hotmaTo: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
il.com cc:
Sent by: Subject: RE: [Q] wield create view error,
need help
I have ORACLE 8.1.7 on SUn Server. I have wield problem on create view. If
I only use select .., I don't have error. But if I use createor replace
view ..select ..., I got error and I have DBA right. The statement are:
SQL CREATE OR REPLACE VIEW DBE_SYNONYMS ( OWNER,
2 SYNONYM_NAME,
Title: RE: [Q] wield create view error, need help?
see answer below
-Original Message-
From: dist cash [mailto:[EMAIL PROTECTED]]
I have ORACLE 8.1.7 on SUn Server. I have wield problem on
create view. If
I only use select .., I don't have error. But if I use
createor
Hello Everybody
I am running 8.1.6 on Solaris 8. I created a standby on different
server from primary database. I also create locally managed temporary
tablespace. I am trying to bring up standby in read only, which I can
accomplish successfully, but when I try to query the standby, I get
When detail_comments in the testable is inserted or updated too then I want it
to update the various_comments column which is in the same table (testtable).
What would be the most efficient way to write the trigger to do this?
CREATE OR REPLACE TRIGGER ADD_TO_TESTTABLE
AFTER INSERT OR UPDATE
Hi,
We are facing problems during veritas
net backup of oracle database on Nt, The database
comes down crashing saying the log file is locked, How can we solve this probs, has anybody faced this probs
and if so can you please let me know how to solve this issue.
I cannot bring this down
Are
you using the Oracle Agent to backup the DB files or you are just using the open
file option?
Regards
Naveen
-Original Message-From: Arun Chakrapanirao
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, October 16, 2002 5:44
PMTo: Multiple recipients of list ORACLE-LSubject: Need
help
AM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Need help from
anybody using veritas netbackup on Nt
Are you using the Oracle
Agent to backup the DB files or you are just using the open file option?
Regards
Naveen
-Original Message-
From: Arun
netbackup has an Oracle agent that should be installed as part of the
netbackup installation.
I know they had installed it for the Unix servers when I was there.
Rachel
--- Arun Chakrapanirao [EMAIL PROTECTED] wrote:
No they are just using the open file option is there any other oracle
agent
of list
ORACLE-LSubject: RE: Need help
from anybody using veritas netbackup on Nt
Are you
using the Oracle Agent to backup the DB files or you are just using the open
file option?
Regards
Naveen
-Original
Message-From: Arun
Chakrapanirao [mailto:[EMAIL PROTECTED]]Sent: Wednesday
.
Regards
Naveen
-Original Message-From: Arun Chakrapanirao
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, October 16, 2002
7:39 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: Need help from anybody using veritas netbackup on Nt
No they are just
using the open file option
]
|
--
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Arun
Chakrapanirao
Sent: Wednesday,
October 16, 2002 7:14 AM
To: Multiple recipients of list
ORACLE-L
Subject: Need help from anybody
using veritas netbackup on Nt
Hi,
We are facing problems during
veritas net
:
Need help from anybody using veritas netbackup on Nt
Hi,
We are facing problems during
veritas net backup of oracle database on Nt, The database comes down crashing saying the log file
is locked, How can we solve this probs, has anybody
faced this probs and if so can you please
Arun,
We use Veritas Netbackup to backup the database. IT LIES when is says
that it is backing it up without a lock. Work with your vendor to get it
straightened out if you can.
The Oracle agent will effectivly perform the hot backups and work
with netbackup to copy the datafiles that are in the
02
7:14 AMTo: Multiple recipients of list ORACLE-LSubject:
Need help from anybody using veritas netbackup on Nt
Hi,
We are facing problems during
veritas net backup of oracle database on Nt, The database comes down crashing saying the log file
is locked, How can we solve this
Hi All,
I want to load PDF files into the database and view the content of the lobs column. Below is what I did step by step. Anyone please point out what did I do wrong in my procedure. I am still unable to view the content of the Lobs column. I need you all for your help.
Please note that I
Unix scripts is one thing I don't worry much and am taking my own time to
learn those with Perl. We got a fantastic bunch of Unix admins who are just
waiting for challenges and always deliver.
It is bad (for me) and good (that I can spend more time on Oracle issues
like chasing OWS personnel and
: RE: Unix scripting need help
[EMAIL PROTECTED
to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Unix scripting need help
Blimey! Doesn't anyone know korn shell out there any more. Perl perl
perl -- that's all I ever hear anymore. It gets old... (I'm gonna have to
buy
I've been an Oracle DBA and developer for many years (more than 10) and I
have also been a Unix Sys Admin (about 5 years). I am used to playing god
with the server , where I am the DBA and the System Administrator. (Of
course these days, a lot of companies and clients want a segregated
Hi all,
For example, my files are like these
mylogfile001.log
mylogfile002.log
I want to initialize my variables with those number, like this
i=1
for all_file in `ls -1 /tmp`
do
file$i=all_file
i=i+1
done
file_tag1=`unix_command $file1 ` --- help me here
BDY.RTF
Description: RTF file
hi
for a in *.log; do echo $A; done
for a in $(ls path/*.log); do echo $; done
instead of echo use whatever you need.
[EMAIL PROTECTED] 08/26/02 12:31 PM
Hi all,
For example, my files are like these
mylogfile001.log
mylogfile002.log
I want to initialize my variables
-- [EMAIL PROTECTED]
echo $all_file | sed 's/mylogfile//g' | sed 's/\.log//g
echo $file | sed 's/[^0-9]//g'
avoids problems if someone decides to add a dash or sometning
into the name.
--
Steven Lembark 2930 W. Palmer
Workhorse Computing
For example, my files are like these
mylogfile001.log
mylogfile002.log
I want to initialize my variables with those number, like this
i=1
for all_file in `ls -1 /tmp`
do
file$i=all_file
i=i+1
done
file_tag1=`unix_command $file1 ` --- help me here
when
Blimey! Doesn't anyone know korn shell out there any more. Perl perl perl -- that's
all I ever hear anymore. It gets old... (I'm gonna have to buy Jared's book one of
these days).
x=${file1%.log}
file_tag1=${x#mylogfile}
Kevin Kennedy
First Point Energy Corporation
If you take RAC out of
]
08/26/02 02:41 PMcc:
Please respond toSubject: RE: Unix scripting need help
ORACLE
Platform: Dell 8200 / XP Prof.
I previously had 9.1 installed on my stand alone
PC.
I de-installed 9.1 and removed all associated
files.
I installed 9.2. Everything went fine until I got near
the end when I ran into an error.
The feedback I got is:
Oracle net config. asst.
succeeded
Hello all,
Sorry I am being a bit off topic, but I am
helpless.
What I need to know is the details (how, which file
to add to, what is the name of the kernel file) of adding storage parameters in
kernel. I need for 3 systems, that is Solaris 8 or any version, AIX 4.2.2 or
above, and HP-uX
Hi,
Thanks for all the replies. I am still unable to archive my redo logs in order to back them up.When startup the database I then enter
archive log list;
Itshows archiving information for the coonected instance:
Database log modeARCHIVELOG
automatic archival DISABLED
Archive destination
I did switch a database's archiving mode from NOARCHIVELOG to ARCHIVELOG.I then enabled automatic archiving of filled groups by setting
log_archive_start=true
in the database's parameter file. Finally I used
alter system archive log start;
to enable automatic archiving of filled online redo log
You probably received an error in your alert log and Oracle disabled archiving. Make
sure yuou have these 3 parameters in your initsid.ora and set accordingly:
log_archive_dest = /oracle/data/arc/sid/
log_archive_format = sid_%s.arc
log_archive_start = true
hth,
Gene
[EMAIL PROTECTED]
Trang: I think that you missed the step of alter database archivelog while
the database is mounted but not open.
Here is the precise steps for you to review:
Modify the init.ora file with log_archive_start = true (you've already done
that)
Shutdown the database.
STARTUP MOUNT
ALTER
You have to have permission to export a database or scheman which is not
your own. At least dba privs..
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, April 18, 2002 12:58 PM
This is a valid user in database but not to export
1 - 100 of 200 matches
Mail list logo