Hi friends
wish u all a very happy new year
i am getting the following error when i run my report
REP-1219: '' 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 to rebuild it
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
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!! :-(
Di
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
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 rememb
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" pa
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
Se
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 enqueu
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
from
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 PROTECTED
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, Sep
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
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, fname
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? Lname
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
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
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)
eter (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.
> > The sqlnet.authentication_services=(NTS) parameter is enabled and we do
> > not want to change the
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.
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
> 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)
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
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 er
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 * ' ||
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
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 to_char(b.dateorder,'mm')
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 like
shava Murthy(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
stati
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 experi
t ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: 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 comput
uster statistics, 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
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 when
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
doc
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 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
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 the
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 ar
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 PRO
our environment are change to ORACLE 9iR2 database and
clients. We plan
to use LDAP on ORACLE client (NO ORACLE AS in
between). Does anyone can
give me some hints which paper, document or web site
will help me on set
it up?
Thanks.
__
Do y
build 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-l
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 66
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
g_colName is a string of column names that I build earlier in the algorithm. My
problem is how do I do the 'INTO' part of this cursor, since I do not know how many or
of what type my columns are. The query is on the fly and totally dynamic.
Anyway to do this without using DBMS_SQL package?
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 tabl
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
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 d
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
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 once
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:
-From: Baswannappa, 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
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 Baswann
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
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
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-- Mailin
echiel
Adar
To: Multiple 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 := i
rence'). 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
hish
- Original Message -
From:
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
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
PROTECTED]>
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 . .
2 11:24 AM
Please respond 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
egories,
because an ODS (not a DW, not another "operational system", 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 OR
Jared Still
com> cc:
Sent by: Subject: Re: Need Help on
Operational Data Store
[EMAIL PROTECTED]
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 warehouse expert at
the least, but several years ago I studied the literature quite a bit and
tried t
ared Still
com> cc:
Sent by: Subject: Re:
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 since
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
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,
http://www
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 c
f list ORACLE-L <[EMAIL PROTECTED]>
Subject: RE: [Q] wield create view error, need help?
Date: Wed, 23 Oct 2002 17:08:28 -0800
see answer below
> -Original Message-
> From: dist cash [mailto:mccdba@;hotmail.com]
>
> I have ORACLE 8.1.7 on SUn Server. I have wield problem o
cash"
il.com> cc:
Sent by: Subject: RE: [Q] wield create view error,
need help?
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
ORA-
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
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,
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 O
ay, October 16, 2002
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
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 th
pients 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 probs, has anybody
faced this
]
|
--
-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
.
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
59
AMTo: Multiple recipients 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:[EMA
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
> ag
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
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
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 d
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
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
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
environmen
2:41 PM
Please respond 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 an
"Ron Thomas"
.com>cc:
Sent by: Subject
ROTECTED]
08/26/02 02:41 PMcc:
Please respond toSubject: RE: Unix scripting n
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 O
> 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
-- [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
hi
for a in *.log; do echo $A; done
for a in $(ls /*.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 wi
BDY.RTF
Description: RTF file
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
wh
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.
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-u
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;
It shows archiving information for the coonected instance:
Database log mode ARCHIVELOG
automatic archival DISABLED
Archiv
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 DATAB
1 - 100 of 218 matches
Mail list logo