Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 119091

Oracle Database 11g Release 2. Please also tag oracle for search purposes.

0
votes
3answers
I'm not sure my question is clear so let's me rephrase it. I have three tables organized like that: I want to make a dump of these tables but I'm not interested by all the rows, I just want those w …
asked Jun 1 '17 by Pierre
0
votes
1answer
I want to create a new stored procedure but I got this error: 00955. 00000 - "name is already used by an existing object" The problem is I don't remember to have created an object with this name a …
asked Jun 22 '17 by Pierre
0
votes
As @JSapkota said in the comments, I need to use CBO instead of RBO. To do it, I need to gather stats on the EVENT table: EXEC DBMS_STATS.gather_table_stats('USER', 'EVENT'); This time, the index i …
answered Jun 13 '17 by Pierre
0
votes
1answer
I'm following the Oracle documentation to create indexes with Oracle Text. The problem is, when I update my data and want to synchronize my index with the CTX_DDL.SYNC_INDEX procedure (according to th …
asked Mar 9 '17 by Pierre
1
vote
1answer
I want to create a simple job who have to execute this shell command: echo some_text > some_file The attributes some_text and some_file can change between two calls to run_job so I need to use set_ …
asked Jun 23 '17 by Pierre
0
votes
To perform this operation, the user who executes the SYNC_INDEX procedure has to be the owner of the index. So, in my case, I had to give the execution rights on the package with the CTXSYS user: GRA …
answered Mar 14 '17 by Pierre
1
vote
1answer
I want to know the space used by one of my indexes. I query the view DBA_SEGMENTS to do it: SELECT segment_name, sum(bytes) FROM dba_segments WHERE segment_name LIKE '%INDEX_NAME%' GROUP BY segment_n …
asked Mar 9 '17 by Pierre
0
votes
The DBA_OBJECTS view describes all the objects in the database. In it, you can find, by instance, the name of an object, its owner or its type. Example: SELECT owner, object_name, object_type FROM d …
answered Jun 22 '17 by Pierre
1
vote
I found a patch to this problem. The idea is to create a bash file: #!/bin/sh echo $1 > $2 And now, you can create and run your job: exec dbms_scheduler.create_job('write_file','executable','/usr/ …
answered Jun 26 '17 by Pierre
0
votes
1answer
I have a table EVENT with a column DATE_RECEIVED (the type of this column is DATE): CREATE TABLE "EVENT" ("EVENT_ID" VARCHAR2(60 BYTE) NOT NULL ENABLE, [...] "DATE_RECEIVED" DATE, [...] ); …
asked May 31 '17 by Pierre