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 (
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 ORAC
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,
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
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 "
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 parti
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 str
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 invol
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
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
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 y
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-
Se
h 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 each partition into separate tablespace
Help given
-Original Message-
Sent: Wednesday, April 03, 2002 12:06 PM
To: Multiple recipients of list ORACLE-L
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT sp
equired. So how it can be managed to put the code in the DDL 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 O
>
>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
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 neede
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 y
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 Oracle
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
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
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
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
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]]
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 FORMAT
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
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
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 proces
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 0
Title: RE: help needed in data datatype
Harvinder, insert it with the time. See below. Try your example with sysdate and you'll see what I mean.
16:33:03 (CRS.WORLD-CRS)>create table lisa (datetest date);
Table created.
16:33:10 (CRS.WORLD-CRS)>insert into lisa values (sy
31 matches
Mail list logo