Yes, those look like the backupset files. I don't know what the default
filename format is, but the filename format and location are configurable
via the format option. You should check out the sample Rman stored scripts
in $ORACLE_HOME/rdbms/demo/*.rcv. For example I use this for my datafile
Check documentation for the composition of the %U filename format; I
believe that it is the default...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, September 01, 2002 10:13 AM
Yes, those look like the backupset files. I don't know what
Dear List,
This is what I'm trying to do in a stored procedure.
1) Read a long raw column from a table into a varchar2 variable. (Let's
assume that each value contains a not-too-long text value.)
2) Parse it to create a bunch of insert statements and execute them.
Step 2 is something I
You convert LONG to CLOB and then read it into your character variable using
DBMS_LOB.READ.
Alternatively, you can use Java and/or EXTPROC.
On 2002.09.01 15:48 sun449 wrote:
Dear List,
This is what I'm trying to do in a stored procedure.
1) Read a long raw column from a table into a
Thanks all the responses.
It's the syntax error like Naveen said. Oracle didn't detect the error, it just simply
ignore the hints if the syntax is wrong.
Thanks again,
Chuan
-Original Message-
Sent: Friday, 30 August 2002 5:33 PM
To: Multiple recipients of list ORACLE-L
If you
Am I missing something? this works for me:
create table testlong (c1 number,c2 long raw);
insert into testlong values (10,'0123456789abcdef');
declare
m_c1 number;
m_c2 varchar2(2000);
begin
select * into m_c1,m_c2 from testlong;
dbms_output.put_line(m_c2);
end;
-Original Message-
OK guys. I found it.
Starting up RMAN with recovery catalog.
the
list backup
command will list the backups and the locations and the file names.
ltiu
On Friday 30 August 2002 22:13, ltiu wrote:
What's the file name format of the RMAN backup set? I see files in there
that I suspect are my
There is nothing wrong in having a comma in a hint:
SQL create table test_hint ( c1 number not null , c2 number);
Table created.
SQL
SQL create index testix1 on test_hint (c1);
Index created.
SQL
SQL set autotrace on explain;
SQL
SQL select * from test_hint a;
no rows selected
This is a multi-part message in MIME format.
--=002_Dragon033825381083_=
Content-Type: text/plain;
charset=GB2312
Content-Transfer-Encoding: quoted-printable
Adriano Freire=A3=AC=C4=FA=BA=C3=A3=A1
=A1=A1=A1=A1This is the limit of oracle8i in linux.Redhat support 2GB=
file in
Hi,
We are planning to use ArcServe 2000 Agent for Oracle to take Hot Backup of
our one of the databases. I was wondering whether anybody encountered any
issue?
Thanks for youe feebback in advance.
Jahan
Environment:
ArcServe 2000 Agent for Oracle
Windows 2000 SP2
Oracle 8.1.7.2.1 Standard
1.)
People are saying that if a table is indexed then the all the
rowids will be changed , whether it is trueIf so , then how it
is done , give example please.
2.)What are all the ways for the rowids to be changed
Explain.
Regards,
Prakash.
--
Please see the official
Prakash,
Though i don't remember fully, but the ROWID consists of the Block Address,
DataFile and other info.
Rowid's change when the row is migrated to a different location.
Since creating index doesn't migrate the row, if the table is indexed the
rowid's wont change.
Naveen
-Original
Creat index will not change rowids. Rowids are not easily changeable.
Here are the evil ways of changing rowids:
a) alter table move ..
b) Update moves the row from one partition to another.
c) Update of the cluster key moves the row from one cluster block to another.
d) Update of the
Hi friends,
I have a tables A and B
DESC A
ID
NUMBER
NAME
VARHAR2(10)
DESC B
---
ID
NUMBER
SUBNAME
VARCHAR2(20);
In the above table B.ID is the foreign key to
A.ID.
How can I create unique value for B.SUBNAME based
on A.NAME.
Means , A.NAME has value
Hey guys,
This one is good!! Runs on Linux and Windows and maybe Solaris too.
http://www.globecom.se/tora/overview.htm
http://www.globecom.se/tora
http://sourceforge.net/project/showfiles.php?group_id=16636
ltiu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
Dear Guess Who,
I don't think so.
BTW, who are the people and why do they think so, we would love to see their
explanation/theory.
There could be several possibilities for having the rowids changed, like
Exporting and Importing the tables, Moving the tables to diff T.S
17 matches
Mail list logo