Recent questions tagged oracle10g

0 votes

418 views

1 answer

oracle10g - Oracle - Materialized View still accessible during complete refresh. How does this work?

In one of our applications, we have a massive Materialized View that refreshes three times a day, and takes ... view is being refreshed? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

437 views

1 answer

oracle10g - Wildcard query expansion resulted in too many terms

I am receiving a "wildcard query expansion resulted in too many terms" error when executing a query similar to ... /solution to this problem? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

409 views

1 answer

oracle10g - Oracle 10g: Can CLOB data lengths be less than 4,000?

We have three databases: dev, staging, and production. We do all our coding in the dev environment. We ... the same across all environments. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

305 views

1 answer

oracle10g - Run 2 queries at the same time on Oracle SQL Developer?

I need to retrieve quite a bit of data from our oracle DB and to do so I need to run 20+ queries. Is there ... t have to start them one by one. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

385 views

1 answer

oracle10g - How to export empty tables in oracle

I have a big problem When i take a dump of database the empty tables are truncated How i can export the ... exp SYSTEM/password FILE=expdat.dmp See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

436 views

1 answer

oracle10g - How to export empty tables in oracle

I have a big problem When i take a dump of database the empty tables are truncated How i can export the ... exp SYSTEM/password FILE=expdat.dmp See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

280 views

1 answer

oracle10g - Oracle query that will list of the database objects referenced by a view

Is there an Oracle view that will list all of the database objects referenced by the DDL of a ... REF_OBJECT_TYPE TABLE_A TABLE VIEW_A VIEW See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

950 views

1 answer

oracle10g - Oracle error ORA-22905: cannot access rows from a non-nested table item

here's the stored procedure i wrote.In this proc "p_subjectid" is an array of numbers passed from the front ... wrong with the my procedure. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

332 views

1 answer

oracle10g - ORA-01652 Unable to extend temp segment by in tablespace

I am creating a table like create table tablename as select * for table2 I am getting the error ORA-01652 Unable ... me 40,000,000 records. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

328 views

1 answer

oracle10g - Is it ok to use oracle 11g client with a 10g server?

I am creating a .NET program that uses odp.net, specifically the 11g version. Our oracle server is running 10g ... client against a 10g server? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

492 views

1 answer

oracle10g - DISTINCT results in ORA-01791: not a SELECTed expression

select DISTINCT a.FNAME||' '||a.LNAME from AUTHOR a, books B, BOOKAUTHOR ba, customers C, orders where C. ... DISTINCT. How to make it work? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

369 views

1 answer

oracle10g - Checking oracle sid and database name

I want to check SID and current database name. I am using following query for checking oracle SID select ... idea for above two problems? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

oracle10g - Delete with Left Join in Oracle 10g

I have the following code that works fine in MS SQL Server: delete grp from grp left join my_data on grp.id1 ... . So, what is the alternative? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

393 views

1 answer

oracle10g - Oracle Date - How to add years to date

I have a date field DATE = 10/10/2010 sum = 4 (this are number of years by calculation) is there a way to ... 10/2010 and make it 10/10/2014? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

214 views

1 answer

oracle10g - How to find Current open Cursors in Oracle

What is the query to find the no. of current open cursors in an Oracle Instance? Also, what is the accuracy/ ... data? I am using Oracle 10gR2 See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

332 views

1 answer

oracle10g - How to insert/update larger size of data in the Oracle tables?

I want to insert large size of data that character length is more than 10,000. I used CLOB data type to each ... table1 value(1,'values>10000'); See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

497 views

1 answer

oracle10g - Is it possible to kill a single query in oracle without killing the session?

I would like to be able to kill a user's query in Oracle 10.2.0.4 without killing their entire session. ... about ending a query's execution? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

371 views

1 answer

oracle10g - Why are Oracle table/column/index names limited to 30 characters?

I can understand that many years ago there would be this kind of limitation, but nowadays surely this limit could easily ... the name is 'OK'. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags