Title: extracting schema
If you are on 9I, you can use
dbms_metadata.get_ddl. You can also use export/import without data to get schema
definition.
-Original Message- From:
[EMAIL PROTECTED] on behalf of [EMAIL PROTECTED]
Sent: Mon 1/19/2004 5:04 AM To: Multiple recipients
Is there anyway to rename tablespace in Oracle 9202. Thanks
DISCLAIMER:
This message is intended for the sole use of the individual to whom it is addressed,
and may contain information that is privileged, confidential and exempt from
disclosure under applicable law. If you are not the addressee
Owners
are different. I am using fromuser touser.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of anuSent:
Wednesday, December 24, 2003 12:04 PMTo: Multiple recipients of
list ORACLE-LSubject: RE: Export/Import issue.
I think data will never
I am 100% positive . I tried this process 2-3 times using different approach but same
output. I tried to create objects first using no data. I also tried to create objects
as part of loading data but no difference. I enabled 10046 trace for the import
process but that also didnt help, it showing
I am trying to export a table from one database to another. Table in target database
is dropped before importing and is being created as part of import process. During
import process data Oracle is complaining Unique constraint violated and throwing out
following messages. Its complaining on i
I will try to get the output of v$system_event and will send it you guys. In the mean
time I have more question..
I am reading Cary's 'Optimizing Oracle Performance Book'. I am half way thru and over
looked rest of the chapters but didnt find an easy way to analyze thousands of lines
trace file
Not really sure what happened and why we decided to that. I was involved in the
beginning of project and remembered that PM was mentioning about talking to another
Logician client who were facing same issues.
-Original Message-
Jamadagni, Rajendra
Sent: Thursday, December 11, 2003 10:55
Hello Everyone, I am trying to get some help/suggestions reg. how to troubleshoot
performance issues.
Little back ground about our environment. Its third party application (Logician) from
GE. There are total 11 databases, all on oracle 8174 H-UX 11i in cluster environment.
All the databases are
Full error message is
ORA-04031: unable to allocate 4032 bytes of shared memory ("large pool","unknown
object","session heap","frame segment"))
I am already monitoing both shared pool and large pool free memory every 30 minutes
and there is no issue with that. As I mentioned below Oracle i
Hello List, Need some help in resolving ORA-4031 error message. We are using Lawson
and for last few days users are getting ORA-4031 error 2-3 times a day in LAWSON log
files but there is no error message in alert log file or any trace file. Both shared
pool and large pool is set to 1GB. Below i
I dont
think you can compress rman files while backups are running. RMAN doesnt support
external compression while backups are running 'cause RMAN has to validate
backups. You can compress all the files once your backup is completed. I tried
that in the past but didnt work. Infect there are
Its possible 'cause we are two different OS and DB versions. Would it be possible if
we upgrade source database from 816 to 8174 and then use Standby database.
-Original Message-
Sent: Thursday, September 25, 2003 5:25 PM
To: Multiple recipients of list ORACLE-L
Avnish:
That is not po
We are planning to migrate one 600GB OPS (2 nodes) database from AIX 433 Oracle 816 to
AIX5.1 Non OPS Oracle 8174. Is it possible to use Oracle standby database of two
different versions of OS and database.
DISCLAIMER:
This message is intended for the sole use of the individual to whom it is a
Yes please, my email id is [EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, September 24, 2003 7:05 PM
To: Multiple recipients of list ORACLE-L
"Compress to impress?" by Julian Dyke is a good presentation on this
topic (see for instance http://www.ukoug.org/calendar/jan03/jan30ab.h
Does anybody has any experience with Oracle 9I compression option. I did some test on
9202 with a table of more 14 million rows. Table has total 7 indexes. Surprising both
table and indexes are using more space after compression. Before compression space
used is 13064MB and after compression 131
Title: Message
Not
really, except to watch closely your hit ratio for no default cache other than
that we used alter table move and alter index rebuild online option to move
tables/indexes.
-Original Message-From: Mladen Gogala
[mailto:[EMAIL PROTECTED]Sent: Wednesday, September
Title: Message
I have
little bit experience on that. I am keeping indexes in 32K block 'cause
Oracle access indexes sequentially and placing indexes in large block would help
in reducing IO. All the tables are in 8K block size but
you can think about putting small tables in 2K or 4KB block
In 9202, DB_BUBBER_CACHE, SHARED_POOL, LARGE_POOL and JAVA_POOL can be dynamically
altered. But in 901, LARGE_POOL and JAVA POOL are static.
If MAX SGA is less than 128MB then Oracle will use 4MB granule size to
allocate/deallocate memory. For SGA greater than 128M, Oracle granule size is 16MB.
Another thing I would check will be tnsnames.ora. I am using it in 9I and I defined
service_name and local_listener init.ora. In the tnsnames.ora I defined SERVICE_NAME
not ORACLE_SID. For listenet I am using self service registration.
-Original Message-
Sent: Thursday, September 18, 20
You
can try to create Oracle linked server in sql server and you should be able
insert from SQL Server to Oracle. I used this approach to get data from DB2 to
SQL Server.
-Original Message-From: Gunnar Berglund
[mailto:[EMAIL PROTECTED]Sent: Thursday, September 18,
2003 1:00
To use service_name, make sure that you have defined local_listener and service_name
in init.ora file.
-Original Message-
Sent: Thursday, September 18, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L
hi all.
i have two databases running oracle 817 on different
machines (AIX 4.3)
Resubmit it and it runs fine until mid night. So I really dont have any
stats for this week.
-Original Message-From: Igor Neyman
[mailto:[EMAIL PROTECTED]Sent: Thursday, September 18, 2003
10:45 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: dbms_job issue.
You
Already tried to resubmit it twice, everytime its breaking around mid
night.
-Original Message-From: Venu Gopal
[mailto:[EMAIL PROTECTED]Sent: Thursday, September 18, 2003
10:40 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: dbms_job issue.
Re-submit the
job…
Hello
List, I am running into weird dbms_job issue. I have a dbms_job to collect
perfstat every 1 hour , job was running fine for last 8-9 months without any
issue. For last 3 days job is stopping every night around 2 AM. I am not
seeing any trace file, any logs in alert file. Any idea what
I have
one question regarding these wait times, may be dump. In the following wait
events what is the unit of measurement for Time, I believe its in seconds as per
the documentation. If yes then here stats
are collected for only 51.23 Minutes (Appx 3073 seconds), how come
Oracle is showing
I am looking for some expert suggestions for the migration of 300GB database to
different hardware. Currently database is 816 OPS on AIX 4.1 nodes. Database is 32bit
and performance on this system is really slow. Export for 2GB table takes 2 hours. All
the data is on EMC symmetric.
We are plann
No, There is no log generated. Below is the only message I am getting.
hp204:NAMES :/home/oracle > svrmgrl
Oracle Server Manager Release 3.1.6.0.0 - Production
Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
ORA-03113: end-of-file on communication channel
SVRMGR>
-Origi
We are using Oracle Name Server in our environment. In the past I heard rumors that
Oracle Name Server is going away. Is it true if yes what other solution Oracle is
providing to replace Name Server. Is it LDAP.
Thanks
DISCLAIMER:
This message is intended for the sole use of the individual to
Applied >250 OS patches on HP-UX 11.11 server and after that getting ORA-3113 error
message every time I do svrmgrl or sqlplus /nolog connect /as sysdba. This database
holds RMAN catalog for more than 30 databases and really very critical. Please share
your ideas.
I already tried to relink and
I tried relinking all and rebooting server then relink again but no luck.
-Original Message-
Sent: Wednesday, August 06, 2003 10:10 AM
To: Multiple recipients of list ORACLE-L
left over memory segments/shared memory/semaphores?
ipcs is your friend, oh and its destructive brother ipcrm :
What are the things I should monitor to make sure that Shared Pool and Log buffer are
set correctly. On one database I have Shared pool GAB and Log buffer MOB, are these
values too high.
Thanks
DISCLAIMER:
This message is intended for the sole use of the individual to whom it is addressed,
a
Title: RE: rebuild index -initial extent - magic??!!
Rebuild will use the same initial extent as it was before but will change
the next extent size. Either drop and recreate index
or You can also think about using Locally managed Uniform
Extent size tablespace, that way you dont have to worr
If its
not an then you can simply run catalog.sql and catproc.sql to upgrade oracle
dictionary tables. Also during 9I installation Oracle ask to upgrade
existing databases on that system.
-Original Message-From: AK
[mailto:[EMAIL PROTECTED]Sent: Tuesday, July 29, 2003 3:54
P
33 matches
Mail list logo
