Question ! When I take export of a particular schema , The dbms_jobs running in that schema are also exported . But when we try to import the whole schema to a...
AMITH UPPAL
uppal_amith@...
Jan 22, 2002 9:16 pm
152
Hi Amith, The job should be imported . It should not be imported if import schema does not have proper privileges. check the export dmp as imp...
Sameer Wadhwa
swadhwa@...
Jan 22, 2002 10:35 pm
153
Hi All, I am storing an XML file into a CLOB column. And I want to retrieve the XML from the CLOB and return a recordset of name and value pairs from the...
Sunil Mohite
sunilvmohite@...
Jan 23, 2002 3:42 am
154
Hi Sunil, This can be done easily by writing a java stored procedure. Just pass the XML in the COLB column as a parameter as type oracle.sql.CLOB and use the...
Sameer , I am importing the schema from coltstream to billrep . The import gives these errors ......this shows that the import tries to create the jobs in the...
AMITH UPPAL
uppal_amith@...
Jan 23, 2002 7:35 pm
156
Hi Amith, Sorry if i am understand this wrongly, Who is the owner of JOB, SYS or COLTSTREAM. If SYS is the owner then you will certainly get the error. Is...
Sameer Wadhwa
swadhwa@...
Jan 23, 2002 8:56 pm
157
... Hi Amith See the error : ORA-00001: unique constraint (SYS.I_JOB_JOB) violated ORA-06512: at "SYS.DBMS_IJOB", line 210 ORA-06512: at line 1 The error...
I would not use ignore=y. This problem needs a real solution. The situation suggests that it would be a good idea to determine if the requirement is for...
Katherine Harms
kharms@...
Jan 24, 2002 5:04 pm
159
hello i am mallikarjuna raju from hyderabd i am interested in oracle database thank u...
I upgraded a server from windows NT 4.0 to Window 2000 server and now I cannot get to my oracle database. Most of the services are started. Does anyone have...
SAB9074
sab9074@...
Jan 24, 2002 6:13 pm
161
When you try to connect what error message do you receive? Katherine Harms Consultant, Peoplesoft Infrastructure EAS IT Infrastructure Consulting Practice ...
Katherine Harms
kharms@...
Jan 24, 2002 6:22 pm
162
Please provide the details including error number. Also your environment variables - ORACLE_HOME, ORACLE_SID etc... using set command from command prompt. ...
Varughese M
varughesem@...
Jan 24, 2002 6:51 pm
163
Jason , I got your point . but the situation is . The original schema is coltstream . I want to move everything from coltstream to another schema called...
AMITH UPPAL
uppal_amith@...
Jan 24, 2002 7:30 pm
164
Can you do like this execute sys.dbms_job.remove(<job id>); declare i as number; BEGIN sys.dbms_ijob.submit (job=>i,luser=>'BILLREP', ...
Sameer Wadhwa
swadhwa@...
Jan 24, 2002 7:40 pm
165
Hi Amith The problem caused in your situation cannot be solved by using FROMUSER/TOUSER parameters in import. The jobs are being created in the target database...
Hi, Please look the following SQL Test this with oracle 9i. SQL 1:- ... create table emp(empno number constraint emppkNconst primary key using index (create ...
Sameer Wadhwa
swadhwa@...
Jan 25, 2002 9:49 pm
167
Hi, Please look the following SQL Test this with oracle 9i. SQL 1:- ... create table emp(empno number constraint emppkNconst primary key using index (create ...
Sameer Wadhwa
swadhwa@...
Jan 25, 2002 9:57 pm
168
Hi, Please look the following SQL Test this with oracle 9i. SQL 1:- (works only with 9i) ... create table emp(empno number constraint emppkNconst primary key...
Sameer Wadhwa
swadhwa@...
Jan 25, 2002 10:09 pm
169
Hi Sameer, The SQL Syntax has been changed in Oracle9i not to improve prformance etc. They have changed to make SQL statements more portable across databases. ...
Question ! Lets say I want to get a week ending report . I mean want to get the date for last day of each week thats saturday . How can I get that date ? Amith...
AMITH UPPAL
uppal_amith@...
Jan 31, 2002 4:52 pm
172
Hi, Try this... select tran_date,amt from some_table where to_char(tran_date,'day')='saturday' or select tran_date,amt from some_table where...
Varughese M
varughesem@...
Jan 31, 2002 5:30 pm
173
Latest News :-- #9658;Because of lots of requests, the exam rates are slashed drastically Check the rates at the end (MCSE pack & CCNA +CCNP pack for as low as...
vicky s
vicky75_vicky@...
Jan 31, 2002 5:43 pm
174
Hi Guys I have around 400 oracle databases on versions 8.0.6.3 & 8.1.6.3. Full Exports are running every day on all of them, but failing very often, with...
Rajesh Arora
arora_rajesh@...
Feb 1, 2002 2:19 am
175
Dear We want change the name of the database. Pl give us solution Visaka Team ... Do You Yahoo!? Yahoo! Auctions Great stuff seeking new owners! Bid now!...
p k s subrahmanyeswar...
bpkssrao@...
Feb 1, 2002 6:29 am
176
We have Dell 8450 server machine with four processors. We would like to install Oracle Database. Do we have to purchase four processor licence or we can go for...
namaliq
namaliq@...
Feb 1, 2002 11:42 am
177
Since the Oracle will use the 4 processors, you will have to purchase for 4 CPU. It doesn't matter that another application resides on the machine. Unless you...
Hi Nadeem, You need to buy Oracle licenses for each of the processor that you use. Confirm with your oracle sales representative first before deploying oracle...
Hi Rajesh, Getting ora-1555 on large exports with 'CONSISTENT=Y' is common. The only way to guarantee that you will not get ora-1555 is to do the export when...
Hi Amith, Calculate the date for last day of each week thats saturday by the below formula. sysdate + 1 + ( 7 - to_char(sysdate+ 1,'D')) Thanks Jason ...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
