Hi Everybody !!
Pl. help me out from this problem !!!
My Boss had asked me to Compile a Pro*C after making some very simple
Changes.
This was a running program.
I had tried to comiple with
$make -f proc.mk petrol
Make: Don't know how to make petrol. Stop.
Environment is
1.digital unix
2. O
Dictionary managed tspaces are practically
obsolete...Go with locally managed - they are the
default in 9i and as of 9i.2, *all* tablespaces will
default to locallly managed (including system)
hth
connor
--- Arul kumar <[EMAIL PROTECTED]> wrote: > Hi
DBAs,
>
> I would like to know on what basi
A Cold Backup is always a Full backup --- all datafiles (and, highly
recommended, all control files
and redo log files).
Did you shutdown the database twice but only backup 6 files each time ?
How many log switches
occurred between the first backup and the second ? If the transactions are
still i
I would assume that the source code file either isn't there or is not called
petrol.pc
HTH
Lee
-Original Message-
Sent: 02 January 2002 09:05
To: Multiple recipients of list ORACLE-L
Hi Everybody !!
Pl. help me out from this problem !!!
My Boss had asked me to Compile a Pro*C after
Connor McDonald wrote:
>
> Dictionary managed tspaces are practically
> obsolete...Go with locally managed - they are the
> default in 9i and as of 9i.2, *all* tablespaces will
> default to locallly managed (including system)
>
> hth
> connor
>
> --- Arul kumar <[EMAIL PROTECTED]> wrote: > Hi
I've tested OCP... and it's not that it is totally valueless (if
nothing else it can show that someone is willing to learn) but that
WHAT OCP teaches you does not tend to apply in the real world.
I won't reject a resume out-of-hand if they have OCP on it, but they'd
better have something else tha
hahaha! i found it!
i found the answer to my problem
the part that causes the error was the order by clause using an alias...
i tried to change the sql for the view using the whole exp
(((sq.last_trade_price - sq.previous)/sq.previous) * 100) in the order
by clause instead of the "perc_change
Nice stuff :
http://www.intelinfo.com/newly_researched_free_training.html
http://www.intelinfo.com/free_it_training_materials_and_books.html
http://w3.softlookup.com/
http://www.intelinfo.com/cat1.html
http://www.intelinfo.com/cat2.html
--
Please see the official ORACLE-L FAQ: http://www.orafa
I granted myself roles via SYS. I have another user on our server (W2000 /
8.1.7) and I have gone through the same process of granting the new user
roles via SYS. However, when she connects to the DB she gets the message
that the objects don't exist. The owner of the DB is me. What am I doing
Did you mean... "MS SQL
Server is a relational database" and not MS Access?
Regards, Patrice Boivin Systems Analyst (Oracle DBA) Acting Head, System Admin & Operations
Bedford Institute of Oceanography
Fisheries and Oceans Canada
-Original Message-From: Edward Lock
[mailto:[E
Title: RE: Problem Granting Roles
What exactly is the error message - if it is table or view does not exist (ORA-904) then I suspect that it is synonyms that are not working/created.
get the user to select from the full table name sys.x and see what happens.
-Original Message-
F
I am trying to download the three .zip for 9i to my laptop (W2000). The
download goes OK until it gets to 99%. Then I look at Task Mgr. and it says
99% complete Not Responding. Why is it hanging? This has happened to me
three times in a row.
Thanks,
Ken
--
Please see the official ORACLE-L FA
Hi
You own the objects, and the other user can't see them?
Try creating synonyms or add the schemaname in front of the object.
---select * from owner.table;
what roles did you grant (connect resource dba. or something you
created yourself)?
A little more info would help in resolving pro
I assume we're talking Unix here, therefore the command line is:
$make -f proc.mk build EXE=petrol OBJS=petrol.o
Or if your using shared libraries:
$make -f proc.mk build_shared EXE=petrol OBJS=petrol.o
Dick Goulet
Reply Separator
Author: [EMAIL PROTECT
No, Access *IS* a
relational database!
I almost want to add ;P
to the end of that, but it's true! It's just a "compact" relational database,
that resides in one file. It is still SQL based, and geared around objects such
as tables, indexes etc.
A poor man's RDBMS.. That
does the trick
Get Download Accelerator Plus, it downloads things in parallel and
re-downloads corrupted segments.
It won't work with all the Oracle download files (e.g. doesn't work with 11i
patchset), but it works for most of them.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin
ok in the unix world, we have .tnsnames.ora file which overrides a
$HOME/network/admin/tnsnames.ora file.
Is there such a thing in the windoze world. a registry entry
maybe?
thanks, joe
Ken,
Your system is most probably running through the last stage of the download,
where it copies the file to the download destination from your temporary
directory, once the download is complete and verified.. Depending on your
system, and connection this could take a little while to do as each
Joe:
The
Environment variable TNS_ADMIN can direct the location to another
position. It can be stored within
the registry or as a environment variable in windows.
Thank You
Stephen P. Karniotis
Technical
Alliance Manager
Compuware
Corporation
Direct: (248)
865-435
Joe,
You can set TNS_ADMIN as an environment
variable or registry variable in HKLM/Software/Oracle and use it.
I prefer to use a variable instead of
registry variable.
Raj
__
Rajendra
Jamadagni
MIS, ESPN Inc.
Rajendra dot
Dear list !
I'm reposting this , since got no replies yet.
I need to design a backup policy for a VLDB sized some 10TB, running
as close to 24X7 as possible.
I need 2 versions of the policy:
One is the "best case" , i.e. money does not matter, the company can aquire
any software / hardware , th
HI Joe,
>From the documentation:
TNS_ADMIN
Oracle software looks for TNS_ADMIN in one location in the
registry (depending upon the type of Oracle home installed). If you installed
software into the default Oracle home, then any software running from that
Oracle home will look in HKEY_LO
Damn, why don't people use the
manuals. TNS_ADMIN. Actually, you can set the puppy on Unix as
well.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of JOE TESTASent:
Wednesday, January 02, 2002 6:15 AMTo: Multiple recipients of list
ORACLE-LS
I just thought of something... do you have enough disk space for your TEMP
directory.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
Sent: Wednesday, January 02, 2002 10:25 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: OTN Downlo
Dear list !
Having been an Oracle DBA on UNIX & win platforms for past several years, i
feel like i'd like to change something.
Don't get me wrong , i like what i'm doing , but i think it's time to expand
my horizons.
I wouldn't like to completely quit the filed of Oracle/DBAing , but i'd like
to
Ah ha! Revenge of the RTFM! ;P
Original Message-
Sent: 02 January 2002 14:45
To: Multiple recipients of list ORACLE-L
HI Joe,
>From the documentation:
TNS_ADMIN
Oracle software looks for TNS_ADMIN in one location in the registry
(depending upon the type of Oracle home installed). If
Is the role set as her default role? Having the role is not enough.
You can have a role assigned to you but its not necessarily 'active'
at the time.
-Original Message-
Sent: Wednesday, January 02, 2002 4:30 AM
To: Multiple recipients of list ORACLE-L
I granted myself roles via SYS.
Not sure if you can show striping with a command. Using the DF command
usually shows all disks in the disk farm. Alternatively, there is an admin
tool for disk maintenance, but I don't remember the name.
Thank You
Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (2
better work around was to have a modified version of tnsnames.ora file in a
bin directory that we execute our batch files from.
Since this is an rexec and we execute from different directories based on
the userid, we can use the same alias DSS to point to different db based on the
login, de
You could split off a mirror and backup the mirror however, I have never
done that so I am not going
to get into it. I know there are others in the list who have done it for
their backup strategy.
Keep in mind that if you are running in archive log mode you need not backup
every data file at the
Is there a UNIX command to determine what, if any, striping was used when
setting up a server and it's disk?
Sun Solaris 6, 7 and 8 are what I'm specifically interested in.
TIA,
Terry
Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX: 816-300-1801
--
Please see the official ORACLE-L FAQ:
Not to mention that this is something that
you also need to know for the OCP exam;-)
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Kimberly SmithSent:
Wednesday, January 02, 2002 7:05 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: s
Somewhat different, but my son's taking his CCNA (Cisco Certified Networking
Associate) this p.m. He realizes that it's not going to guarantee him a
job, but he hopes it will help him get his foot in the door. He's 19, and
just finished the Cisco networking academy. He took the first year at hi
Generally, if you are on a version of Oracle that has a bug free
implementation of LMT's, then use them.
8.1.7.1 or 8.1.7.2 I believe.
There's no reason not to use them otherwise.
Jared
best case, unlimited funds, you need something like EMC's SRDF or IBM's
HACMP which are remote mirrored solutions.
--- Andrey Bronfin <[EMAIL PROTECTED]> wrote:
> Dear list !
> I'm reposting this , since got no replies yet.
>
> I need to design a backup policy for a VLDB sized some 10TB, runni
If memory serves on Solaris it is called Solaris Online Disksuite or
something like that
-Original Message-
Sent: 02 January 2002 15:30
To: Multiple recipients of list ORACLE-L
Not sure if you can show striping with a command. Using the DF command
usually shows all disks in the disk fa
If the database was shutdown cleanly, the online logs
are not required or desired.
If the database was not shutdown cleanly, you will not
be able to open the database without them.
Jared
well the thing is, he wasn't looking for TNS_ADMIN since that just
re-sets the directory Oracle looks at but wanted something that worked
more like how login.sql works -- where if you have the file in your
local working directory, it is used and overrides any other file.
In Unix, if you have a .t
Judy,
Of course they are. After all, that's what they sell.
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
> -Original Message-
> From: Peddycoart, Judy [SMTP:[EMAIL PROTECTED]]
> I don't yet have my OCP, but my boss is encouraging me to g
thanks a lot Kimberly !
DBAndrey
* 03-9254520
* 053-464562
* mailto:[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, January 02, 2002 5:35 PM
To: Multiple recipients of list ORACLE-L
You could split off a mirror and backup the mirror however, I have never
done that so I am not
Not only is it not in the flaming manuals, I don't think you
can even do that on Windoze.
Sure, you can set the TNS_ADMIN var in
ControlPanel->System->EnvVars, but that is rather broad
in scope and does not offer the granularity available on unix.
Jared
In my research the TNS_ADMIN does not actually "re-set" the directory where
Oracle looks.
The presence of a TNS_ADMIN env var is checked first, if found then this
path is used to locate the tnsnames.ora and sqlnet.ora. If it is not found,
Oracle looks at the ORACLE_HOME env var, if found then it
[EMAIL PROTECTED] wrote:
>well the thing is, he wasn't looking for TNS_ADMIN since that just
>re-sets the directory Oracle looks at but wanted something that worked
>more like how login.sql works -- where if you have the file in your
>local working directory, it is used and overrides any other fi
Andrey,
I think that you are looking at this problem from the wrong end. Rather
than come up with backup scenarious first and reporting back to management,
I think you need to get managment to declare to you their "Mean Time to
Recovery". By this I mean that they need to tell you how long they
You're right - it keeps me gainfully employed! :)
-Original Message-
Sent: Wednesday, January 02, 2002 10:15 AM
To: Multiple recipients of list ORACLE-L
Judy,
Of course they are. After all, that's what they sell.
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
I would also suggest (in a world somewhere between ideal and 'cheapest')
using Veritas NetBackup with the Block-Level Incremental extension for
Oracle. This is really nice for saving on tape costs and backup time - it
performs incremental backups of your datafiles on a block level (thus the
name)
Note, I have been able to find many Oracle white papers using google.com...
-Original Message-
Sent: Monday, December 17, 2001 7:21 AM
To: Multiple recipients of list ORACLE-L
Thanks a bunch, Gopalakrishnan
Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email : [EMAIL PROTECTE
--- Forwarded message follows ---
Will Forms 5 work on Windows2000Pro? Is it (or was
it) officially "supported" by Oracle?
thanks,
ep
--- End of forwarded message ---
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Eric D. Pierce
INET: [EMAIL PROTE
Typically vxprint if you're using Veritas, or metastat
(or cat /etc/opt/SUNWmd/md.cf) for Disksuite.
hth
connor
--- Robertson Lee - lerobe <[EMAIL PROTECTED]>
wrote: > If memory serves on Solaris it is called
Solaris
> Online Disksuite or
> something like that
>
> -Original Message-
>
Title: RE: A DBA's career development
Try learning other databases. That way when you go into a new project, you can decide which may be a better one to use for the job.
i.e. Having oracle for a small in-house database to track your timecards would be serious overkill and costly. Even a fr
vxprint -ht will print it out in nicer format than just vxprint, explicitly
listing the stripe width/colums for each plex.
i.e.:
v index01 fsgenENABLED ACTIVE 97179648 SELECTindex01-01
pl index01-01 index01 ENABLED ACTIVE 97180800 STRIPE5/64
RW
sd index-a-01 i
Thanks a lot to all who replied !
Tom , thanks , i forgot to mention , the DB is expected to get recovered in
something like 1-3 hours.
Another correction , the DB size will be around 1TB for the beginning and is
expected to grow to 10TB within a couple of years.
HAPPY NEW YEAR ALL !
DBAndre
Hi Jared,
Sorry, I misunderstood the question.
Environment variables can, however be set locally instead of at the system
level
tns_admin=
inside of a .bat or a .cmd script, maybe even perl :-)
John
[EMAIL PROTECTED] wrote:
Not only is it not in the flaming manuals, I don't think you
Title: RE: A DBA's career development
Out of
curiosity, is anyone using iFS in a production environment?
Regards, Patrice Boivin Systems Analyst (Oracle DBA) Acting Head, System Admin & Operations
Bedford Institute of Oceanography
Fisheries and Oceans Canada
subscribing).
nope, it doesn't.
in unix, Oracle will check the same path with this exception: it first
looks for a ".tnsnames.ora" file in the $HOME directory of the logged
in user. If the file is there, it is used, if not, Oracle continues to
check TNS_ADMIN and then network/admin
--- eric harrington <[EMAI
ah but you can do something similar, at least according to Joe -- he
found it on a thread on MetaLink.
You put a tnsnames.ora file in your local directory (I would suppose
without setting TNS_ADMIN) and then it will use the local one
interesting, veddy interesting
--- [EMAIL PROTECTED] wrote:
The problem is, most business users say "5 minutes" (and btw, the emc
srdf option is actually faster than a hot standby, since a hot standby
might need log files to be applied while the mirroring does not --
check out Lawrence To's papers)
so you go ahead and figure out what a "5 minutes" scenari
Title: RE: VLDB backup policy
What type of application is it (OLTP, DSS, mixed, etc.)? Also, is it monolithic or can the functionality be broken down into usage profiles (i.e. mostly read, high velocity update, etc.)?
-Original Message-
From: Andrey Bronfin [mailto:[EMAIL PROTECTED
One problem with SRDF though is that it doesn't protect against block
corruption. SRDF is really really cool, but is not a complete backup plan
in and of itself.
George
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, January 02, 2002
Esteem members of the list.
I hope this new year finds you and your's healthy and prosperous.
I have a question on partitioning and the changing of the values assigned to the
partition during creation.
The tablespace was created with AUTOEXTEND ON next 2 M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 2
HI All,
It is in that useless documentation, from the Net8 Administrators Guide
Ensure that the client machine has the tnsnames.ora and the
sqlnet.ora files in $ORACLE_HOME/network/admin
on UNIX and ORACLE_HOME\network\admin
on Windows platforms.
The search order f
absolutely true -- but if they want "instant" recovery, then this will
handle hardware failure
--- George Schlossnagle <[EMAIL PROTECTED]> wrote:
> One problem with SRDF though is that it doesn't protect against block
> corruption. SRDF is really really cool, but is not a complete backup
> plan
We are seeing a lot of shared pool waits (for libary cache pin) on
our 8.1.5 web-based application. We are seeing this via Precise/Indepth
SQL monitoring tool.
I haven't been able to find much documentation on shared pool waits or
library cache pins.
Can anyone tell me what might be causing th
It works really well for a DR site though!!
Greg
-Original Message-
Sent: Wednesday, January 02, 2002 2:20 PM
To: Multiple recipients of list ORACLE-L
One problem with SRDF though is that it doesn't protect against block
corruption. SRDF is really really cool, but is not a complete ba
Andrey,
Valid questions: And the answer? "It depends" :) It depends on some
factors such as the size of your shop and their plans (in case you want to
stay with them), the time (and $$) that you can invest on learning, your own
background, likes and dislike, etc., as well as possible prediction
In one version (I think is was 8.1.6.x.x) analyze stale
didn't work right.
In 8.1.7 (releases the we've tried, .0 and .2), it didn't work
for partitioned tables. The monitor piece appears to work, so one of
the other dba's here wrote a script using all_tab_modifications and dynamic sql
to
Do any of your queries have a high version_count (visible through
v$sqlarea)?
George
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, January 02, 2002 3:20 PM
>
> We are seeing a lot of shared pool waits (for libary cache pin) on
> ou
learn something new every day.
--- orantdba <[EMAIL PROTECTED]> wrote:
> HI All,
>
> It is in that useless documentation, from the Net8 Administrators
> Guide
>
>1. Ensure that the client machine has the tnsnames.ora and the
> sqlnet.ora files in $ORACLE_HOME/network/admin on
Title: RE: VLDB backup policy
check out SharePlex for Oracle. The target system is completely open and available while it is applying the changes from the source. If you are expecting < 25 GB of redo generation per day, it will usually be under 15 seconds latency. And it's a LOT cheaper than
I am having a problem setting up a user on my DB (W2000 / 8.1.7).
I have my self as user KENNETH and the new user is KIMV.
She can access tables via KENNETH.TABLE_NAME or SYS.TABLE_NAME but not jus
TABLE_NAME.
Here is what I have (I am grantee KENNETH and the user I am setting up is
KIMV):
Yes, there are a handful with more than 400.
I'm not sure what high is?
Cherie
"George
Create a synonym for KENNETH.TABLE_NAME coz if she(KIMV) doesn't own it she
will have to prefix the owner before the table_name.
HTH
Shailesh
-Original Message-
Sent: Wednesday, January 02, 2002 4:05 PM
To: Multiple recipients of list ORACLE-L
I am having a problem setting up a user on
Have you created synonyms?
At 01:05 PM 1/2/02 -0800, you wrote:
>I am having a problem setting up a user on my DB (W2000 / 8.1.7).
>
>I have my self as user KENNETH and the new user is KIMV.
>
>She can access tables via KENNETH.TABLE_NAME or SYS.TABLE_NAME but not jus
>TABLE_NAME.
>
>Here is what
Hi Ken,
You have to fully specify all of the roles that you want to be default
in one alter statement
alter user kimv default role connect,db,resource;
should turn all to YES.
You may also need to make sure that your synonyms are public.
Hope this helps,
John
[EMAIL PROTECTED] wrote:
>I a
Cherie,
What constitutes 'a lot of shared pool waits (for libary cache pin)'?
Does it represent a significant percentage of total waits, or is it just
crossing some predetermined threshold?
Is it causing a performance problem?
( as seen by users, not by a monitoring tool )
Jared
I installed on NT 4.0 server. Taking the default install it installes all
and begins to initialize the default database and gives the message
ora-03113(End of file on communications channel) after about 90%
installation. Have tried it from multiple machines with the same results. It
worked fine fo
Arul - I would recommend reading "How to Stop Defragmenting and Start
Living: The Definitive Word on Fragmentation" by Bhaskar Himatsingka, an
Oracle white paper. I was going to provide a link to it, but Oracle's
website search function doesn't seem to work for me right now.
Dennis Williams
DBA
Li
Ken,
Take a look at 'create synonym' in the docs.
There are two kinds: public and private.
For a private synonyms, the user KIMV would need to execute
the statement 'create synonym TABLE_NAME for KENNETH.TABLE_NAME';
For a public synonym, a user with the 'create any synonym privilege' would
Andrey - You may also want to consider positioning yourself toward being a
system architect. How are your data modeling skills? Skills at building a
group consensus?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, January 02, 2002 9:15 AM
To: Mu
Google to the rescue... just one of the many links:
http://www.dbatoolbox.com/WP2001/spacemgmt/defrag.htm
-Joe
At 02:10 PM 1/2/02 -0800, you wrote:
>Arul - I would recommend reading "How to Stop Defragmenting and Start
>Living: The Definitive Word on Fragmentation" by Bhaskar Himatsingka, an
>O
I'd like to be rich and retire now. Spend more time with my family and kids.
Also spend more time in playing Tennis.
When this happens, I do not want to see Oracle:)-
But can't!
-Original Message-
Sent: Wednesday, January 02, 2002 10:15 AM
To: Multiple recipients of list ORACLE-L
De
Just skip the default database.
If you really want it, just have the installer generate scripts then
run the scripts manually.
Jared
"Gordon, Emery
"Khedr, Waleed" wrote:
> I'd like to be rich and retire now. Spend more time with my family and kids.
>...
> When this happens, I do not want to see Oracle:)-
Ooohkay...but you still going to stick with us sorry lot that still have to
fight the
brain-frying, mutant-cyber pokemon-beast, right ???.
Happy New Year!
Agreed! I like so much with locally managed tablespace because every extent
size is uniform, therefore no fragmentation; you don't have to worry about
the number of extents at the table level. I even make the temporary
tablespace to be LMT.
What is the acceptable extent size if
I've always wanted an easy way to extract DDL info
from an import indexfile so I wrote a little perl
script that will extract create table ddl from an
indexfile. Seems to work and is a lot faster than
hand editing. Would appreciate any feedback/criticism
or ways to improve the script.
#!/usr
For indexes, use this:
#!/usr/local/bin/perl -w
# Extract CREATE UNIQUE|BITMAP INDEX statements
# By: MKB Jan 02 2002
# Inputs: Location of log file and file output
# Outputs: Writes to file output
# Modification History:
#
use strict;
my ($infile, $outfile);
m
Finally, to get the ALTER statements from the
indexfile:
#!/usr/local/bin/perl -w
# Extract ALTER TABLE statements
# By: MKB Jan 02 2002
# Inputs: Location of log file and file output
# Outputs: Writes to file output
# Modification History:
#
use strict;
my ($i
You know, I did not intend to leave the Fujitsu account either. But
come the end of March I will be.
-Original Message-
Judy
Sent: Wednesday, January 02, 2002 7:45 AM
To: Multiple recipients of list ORACLE-L
Somewhat different, but my son's taking his CCNA (Cisco Certified Networking
A
Ken,
First a question - what did you do for Oracle when you worked there?
second... KIMV needs a synonym for the table to be able to refer to it
with an owner qualifier
third, you can only have ONE default role. Think about it. If you
really want the user to have the privs of several roles at
Have u tried disabling the timed_statistics=false in 8.1.5 there is a bug I
am not sure.
But try this out,
When you are saying u are seeing very high version_count,then I have a
feeling it pointing to that bug.
Try disabling the timed_statistics and see.
>From: [EMAIL PROTECTED]
>Reply-To: [E
Dear Andrey and other Fellow DBA's,
For quite some time I have been wondering about the same fact that Andrey has thought.
I started my career Oracle 7 DBA and moved on. When 8 was released, we quickly did not
upgrade the db. Now when 9i is released, with so many things in it, I asked myself
wh
Hi,
Queries with high version counts can cause library cache latch contention, as the query must hold that latch during soft parse and has to go through the entire list of query versions in the data dictionary. High version_count's are often caused by a high number of invalidations on the query.
93 matches
Mail list logo