Jay,
Check http://www.oriole.com/aunt_2001_0.html
and look for the 19th. March 2001 entry.
Otherwise look for a snp*.trc in either bdump or udump (never remember where it goes).
HTH
SF
- --- Original Message --- -
From: [EMAIL PROTECTED]
To: Multiple recipients of list
Stephane,
This is what I was exactly looking for. Thank you so much.
- Original Message -
Date: Friday, November 14, 2003 8:59 am
Jay,
Check http://www.oriole.com/aunt_2001_0.html
and look for the 19th. March 2001 entry.
Otherwise look for a snp*.trc in either bdump or udump
Hi,
I'm currently looking into the
same.
My idea is to create a new table with the
partitions I need, insert the data from the old table, drop the old table and
rename the new table to the old name.
This will invalidate a lot of stuff, which I
still have to find out exactly what, so if
Jack, Munish
First, verify that you have licensed partitioning. Additional cost item.
Second, learn about EXCHANGE PARTITION. This is a highly useful command that
can be used for a multitude of uses. Create a partitioned table and then
exchange your table into it. Extremely fast since it just
Munish,
innocent question, _why_ do you think partitioning will help query
performance? Have you checked asktom site?
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are
Read about exchanging partitions in chapter 17 and especially Converting a Partition
View into a Partitioned Table :
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/toc.htm
Even though you may not be using a partitioned view, you can use this technique to
create the
That is the greatest RTFM answer that I've ever seen!
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, June 25, 2003 9:33 AM
To: Multiple recipients of list ORACLE-L
Read about exchanging partitions in chapter 17 and especially
You first create an empty partitioned table
with the same structure as the original table
and then use "exchange partition" to
exchange partitions with the original table. That way, your original
table
will end up having a single (empy)
partition and the new table will have a full partiton.
Thanks for mentioning it
Just tried a little test and worked like a charm.
alter table part2 exchange partition JUNE2003 with table test_part1
Jacob A. van Zanen
-Original Message-
Sent: Wednesday, June 25, 2003 4:14 PM
To: Multiple recipients of list ORACLE-L
Jack, Munish
First,
Title: RE: HELP NEEDED IN FORMS6I OR FORMS9I DEVELOPMENT - WEB
if you have activex controls that you want to replace, there is 'Java Importer' and in Forms 9i you can use PJCs also.
Read through Forms information at http://technet.oracle.com
Raj
Put each partition into separate tablespace.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, April 03, 2002 9:18 AM
HELP
Hi,
I am working with Oracle 8i version in our ERP applications. I have
Rakesh,
You have 2 options.
1. Either create the different partitions on different
tablespaces and take backup of selected tablespaces
2. You can take a logical backup using the export
utility by providing a query clause for the table.
HTH,
Naveen
--- rakesh banerjee [EMAIL PROTECTED]
wrote:
Give each partition its own tablespace and back up the
tablespaces.
--- rakesh banerjee [EMAIL PROTECTED]
wrote:
HELP
Hi,
I am working with Oracle 8i version in our ERP
applications. I have one
question regarding the backup of Oracle database. In
the database I am
designing it is
Rakesh,
Yes. You can certainly export a single partition at a time for logical
backups. If you put each partition in its own tablespace, you can
physically back up individual partions as well.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP
Rakesh,
Keep in mind the init parameter MAXDATAFILES when you initially build
your database. If the original database was built with a small limit
then you will have to rebuild to change the MAXDATAFILES parameter.
Search the metaslink site for information on changing the parameter if
you think
script
so that it assigns the tablespace automatically. Waiting for ur reply.
With Regards
Rakesh Banerjee
From: Igor Neyman [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Help needed
Date: Wed, 03 Apr 2002 06:53:33 -0800
Put
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you
PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Help needed
Date: Wed, 03 Apr 2002 06:53:33 -0800
Put each partition into separate tablespace.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
help received...
I was responding to the question about the tablespace partitioning
with text and examples. My email package (groupwise) is still randomly
limiting the size of the emails.
Thanks for helping.
Ron
[EMAIL PROTECTED] 04/03/02 01:43PM
Help given
-Original Message-
Sent:
Rakesh,
Keep in mind the init parameter MAXDATAFILES when you initially build
your database. If the original database was built with a small limit
then you will have to rebuild to change the MAXDATAFILES parameter.
Search the metaslink site for information on changing the parameter if
you think
As simple as:
select * from
(select 'ptMASTER' , 'Master' col2 from dual
union
select 'ptMKT' , 'Market' from dual
union
select 'ptOFFICE' , 'Office' from dual)
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
-Original Message-
From: Shishir [SMTP:[EMAIL PROTECTED]]
Thanx Adary !
I could not think in such simple way .
Anyway thanx again..
Shishir Kumar Mishra
Agni Software (P) Ltd.,
Bangalore-560055, India
www.agnisoft.com
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, February 18, 2002 2:13 PM
RTFM on auditing - this should provide all that you need. A good start would
be to read:
Oracle Concepts Guide - Chapter 28 - Auditing.
HTH
Mark
-Original Message-
Sent: Tuesday, August 07, 2001 09:00
To: Multiple recipients of list ORACLE-L
HI DBA Guru's
It has been a painful
Title: RE: Help needed
If on oracle 8i, you may also consider database triggers to prevent ddl stmts, userwise.
rgds
amar
-Original Message-
From: Mark Leith [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 2:35 PM
To: Multiple recipients of list ORACLE-L
Subject: RE
look up auditing it is your friend ;)
joe
Deewaker G.V. wrote:
HI DBA Guru's
It has been a painful process for me everytime when I change the
password of the user in ORACLE.. The reason is simple Some one is
trying to play with the tables and change the INDEXS... delete the
Deewaker,
you can run the listed srcipt to find the users that are connected to your server.
With a little modification you can get all of the information you need.
ROR mª¿ªm
+ user1.sql++
COLUMN SU FORMAT A8 HEADING 'ORACLE|USER ID' JUSTIFY LEFT
COLUMN OSU
If I understand the question, he wants the time to always be
one-minute-to-midnight, and just insert dates. This can be done with a
trigger.
g
-Original Message-
Sent: Tuesday, July 03, 2001 10:56 PM
To: Multiple recipients of list ORACLE-L
Harvinder,
If you want time in a date
Harvinder,
You never inserted the time component of the date so how can you get it
from the database. Either explicitly insert time component or if possible
use a la sysdate/now (datetime function of your tool) when inserting a date.
Shailesh
-Original Message-
Sent: Tuesday, July
28 matches
Mail list logo