logs archiveIRC Archive / Freenode / #oracle / 2009 / November / 20 / 1
Fandekasp
hi
I'm learning Materialized view .. I've executed one in iSQL*Plus, but where could I see my result ? Sorry about this noob question X_X
I'd like to better understand what is a materialized view, that's why I asked this question
Ok sorry, I've understand
Does someone know how to verify if a refresh command is truly written like we should do it ?
I'd like for example to do a refresh on a view once a week at 23pm
Please look there : http://pastebin.com/m6e32af4f
I've written 2 possibles methods ... but are they both correct for my case ?
In any cases, the alter of materialized view is done correctly
Nobody is here ? Thank you in advance for any answer
boingolov
Fandekasp, look at dba_mviews to see if it's happening how you think it should, and also look in the alert log, any errors will show up there
Fandekasp
boingolov : Ok I go look this, thank you for your answer !
indra
hi all
could someone please helpme in deleting the tablespace created by an application
i am using oracle 10g XE
boingolov
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_9004.htm#i2133717
indra, bookmark this: c
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/toc.htm
Fandekasp
boingolov : there is no error on alert log. According to dba_mviews from sys, there is a line with my query, but I don't see when will be the next refresh.. Do you know where is it ?
There is a column "last_refresh_date", but I'd like to see a next_refresh_date to verify if my query was good or not
boingolov
Fandekasp, no such thing
in dba_mviews at least
Fandekasp
boingolov : ok. I'm sorry, I'm not a specialist with oracle. So in http://pastebin.com/m6e32af4f, What would you do to check if my 2 querys are correctly written to check every weeks at 23pm ? Thank you a lot again for your attention
boingolov
Fandekasp, link doesn't work
         

Fandekasp
there is a , at the end
http://pastebin.com/m6e32af4f
boingolov
so you want to do it every 8 days?
Fandekasp
no every 7 days. Each Sunday in fact
boingolov
read the docs
time for bed
night night
usn_work
good (CET) noonmorning
TheBonsai
bla?
Theory
morning from an hour behind
usn_work
:)
mastro
I'm studying an oracle database that I did NOT installed and I need to extract information about it. I already exported the nls_dabatabse_parameters table, is there any other table I should extract? or may be some conf file? (I also have ssh access to the machine)
usn_work
v$parameters
best, create a pfile
mastro
usn_work: googling on how to create a pfile from oracle...
usn_work: I don't have a sysdba role
usn_work
v$parameter(s) contains the same
mastro
usn_work: if I can read/copy the spfile.ora can then convert it locally?
sorry usn_work the company proxy is always going down today.. I may have lost your reply
mgolisch
why do i get ORA-08002?
teite
ask the alert log, or trace file ;)
mgolisch
do i have to use someseq.nextval in a sqlstatement atleast once before i can get the value of currval? its currently inserted using atrigger
but i get this ora message everytime i try to select someseq.currval from dual after inserting into that table
its with jdbc
do i need to supply someseq.nextval as a value in the sqlstatement instead of using a trigger for that to work?
teite
hmm shouldn't that be a >20000 ora code?
mgolisch
ORA-08002: sequence NAME.CURRVAL is not yet defined in this session
teite
yeah
just wondered
usn_work
mastro, you hav not lost anything from me, wasn't here. :)
         

mgolisch
anyone has any clue what iam doing wrong?
usn_work
You have access to spfile.ora but no sysdba role? Can't you connect with sqlplus / as sysdba?
mgolisch,
~> oerr ora 08002
08002, 00000, "sequence %s.CURRVAL is not yet defined in this session"
/ *Cause: sequence CURRVAL has been selected before sequence NEXTVAL
/ *Action: select NEXTVAL from the sequence before selecting CURRVAL
read and think
mgolisch
so i cant use a trigger?
if i need to select sequence.currval?
usn_work
no clue what the heck you are doing
reproduce the problem and pastebin a script so we can see what the situation is
teite
usn_work: i don't get the error message
why do i need to do nextval before curval?
mgolisch
i insert into a table for that i have defined a before insert trigger that uses someseq.nextval to fill in the id columns value
but regardless of that i still get this ora error
usn_work
AFAIK CURRVAL is only valid in the cursor that pulled NEXTVAL. Am I wrong, #oracle?
mgolisch
hm strange, i deleted the triger and made it new, it works now
whatzever
thx for wasting your time
:)
usn_work
;)
teite
trigger are black magic ;)
mator
just hit http://code.openark.org/blog/mysql/sql-pie-chart
teite
sweet :)
mastro
<usn_work> You have access to spfile.ora but no sysdba role? Can't you connect with sqlplus / as sysdba? «« no i thought I have.. but i've no read permission on the file and no I can't log in with sysdba
luisgrin
hi, i have instaled oracle expres 10g on vista, it was working until i resterted the system, then when i wanted to start the database i got error 5
puuck
you tried to start it via the service?
luisgrin
no i dont
i dont know if it is working
puuck
how did you try to start it?
luisgrin
from the program->start database
puuck
and it just says "error 5"?
luisgrin
just one min, the oracle is in other pc
kingbombs
http://pastebin.com/d4e02e25 hey i am trying to create a trigger, where i deref the relationship and then changed a field in that table but i get no compilation errors but nothing gets changed at run time except the fine attribute
didnt include how i made the tables one sec
http://pastebin.com/d2f428332
anyone have any idea what i am doing wrong?
mod_cure
/join #javascript
luisgrin
http://pastebin.com/m5e3c9df5
puuck http://pastebin.com/m5e3c9df5
puuck
try starting it from administrative tools -> services
looks like your user doesn't have all the appropriate permissions
luisgrin
anyway ill try to fix it, BUT I have other installation in and xp, so ill try to restore a dmp in it. The dmp is a 1.7G file, i never used oracle before, i have lot of question, but by now i want to know how to restore this database
kingbombs
anyone able to help me with my problem?
puuck
what is book_tab?
kingbombs
book_table which is create from the book type
oh sorry its called copy_tab of book_tab thats a mistake that happened when i put it into pastebin
http://pastebin.com/d7efacf1c
any ideas?
puuck
do you have some sample data?
luisgrin
i need very basic commands to start like connect to a database, create a new database etc, i mean from the sqlplus command line, thank you
kingbombs
well atm the onLoan attribute is set to 0 for everything and when i insert anything into the loan table i want to it to change the copy table to change the attribute to 1
i don't want to have any if statements yet, just currently nothing seems to get changed but it compiles fine
puuck
it looks like you're just updating a local variable, not the underlying book_t table
kingbombs
how do i do that
i have been searching on the internet
but currently can't find anything useful
neilkod
in 10g, does anyone know where you can see the actual table/column statistics that are being saved, historically?
for instance, dbms_stats allows importing older statistics but i can't find out where i can view them without actually importing them
Egyptian[Home]
afternoon all
i m trying out oracle on linux 64 and i just want to clarify something i read .. its EITHER raw devices OR asm devices NOT both... is this correct?
usn_work
ou can have ASM disks on raw devices
but you should not have data from the Db on raw devices without ASM any more
Egyptian[Home]
usn_work: http://www.oracle.com/technology/tech/linux/asmlib/raw_migration.html <- . What would cause ASM to see a disk twice? Here, it would be because the disk is available via raw access and ASMLib access.
i thought like you until i read that line and now i want to be doubly sure
usn_work
Why don't you just try? What I told you comes from several setups, not from some paper
And you don#t need ASMLIB
And you should really use 11g if you are new and don't need 10g explicitely
ASM is far better in 11g now
mnetizen
(Action) deLurks in #oracle
I've got a developer provided query that contains a '+ 0' at the end of a line in the WHERE clause
My google-fu has failed me, any thoughts what the +0 is?
puuck
oracle still supports raw datafiles
at least for 10g
Egyptian[Home]
usn_work: 10gR2 .. preparing a poc for a possible project
usn_work: conclusion all raw devices should be with asm disks?
usn_work
Do you want to hear my preferred setup? ;)=
Egyptian[Home]
including ocr and voting ?
usn_work: pls do :)
just hope you wont mind if i also use it ;)
puuck
you can't put the ocr or voting disk in asm
usn_work
If it's a possible project, use 11gR1. But this applies for 10g as well
Egyptian[Home]
puuck: thanks ... looks like i m confused for sure on what to go where
usn_work
Use one raw device for each OCR and voting disk
(may be up to five: 2x OCR, 3x voting
)
And use at least one (for EXTERNAL) or two raw devices (for REDUNDNACY NORMAL) fro each ASM diskgroup
puuck, with 11gR2 you can put ocr and voting into ASM, but I won't use R2 now
Egyptian[Home]
usn_work: thats for a rac with more than 2 nodes. right?
usn_work
nots_, it's for redundancy
no, it's for redundancy
no matter how many nodes you have
puuck
really? how do you start CRS then?
usn_work
hehe, the concept is quite funny
you can store OCR and voting in ASM. But the voting disks reside on a known disk, and one on each disk. So CRS bypasses ASM for the start
puuck
looks like r2 actually deprecates putting ocr and voting disks on raw partitions
usn_work
and reads directly for the disks. But once running, you can manage them with ASM. Same for OCR
http://www.usn-it.de/index.php/2009/11/20/doag-konferenz-2009-impressions-day-3-final/ (see the first block about OGI)
puuck
interesting
have you played with 11g r2 at all yet?
usn_work
yes, in my VMware environment
in first week of september, after the release was online ;)
luisgrin
i tryed to imp a dmp file, but as im a newbie i dont know howto list the tables i got, i know something was imported because if i do select * from all_users; i get a users list
but i dont know howto list the other tables in the database
usn_work
all_tables
user_tables
luisgrin
show user_tables or user_tables only?
ok select * from user_tables:)
usn_work
...
all_tables provides an owner as well
it lists not only your tables, it lists tables you have access to
luisgrin
yes, i see, i got 1000s of lines, but i only need lets say those with ts*
usn_work
it's basic SQL
luisgrin
sure
usn_work
use a select statement with LIKE
luisgrin
yes yes,
usn_work
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_10002.htm#SQLRF01702
luisgrin
usn_work i use mysql evey day, i was confused by the huge quantity of objects and commands
usn_work
hehe
What DB version do you use?
luisgrin
i did imp to a oracle 10g express
on xp
the only thnig i did was imo and some 4 diff commands :)
usn_work
For all 10g question, this is a great starting point http://www.oracle.com/pls/db102/homepage
luisgrin
i think i got all the tables bcoz user are the real ones
ok, ill do it
usn_work
if you come over an object or such you don#t understand, type it into the search box
luisgrin
but im really lost
i want to start using the web interface as well
usn_work
I don't want to be cruel sying all that, but this is help to help yourself
luisgrin
yes, you are cruel, but you are right :)
defaultro
morning folks. If I will study oracle, what is the appropriate version to study? I was thinking that I should study what currently is being used in company. Is that correct? However, I don't know which version to use or download
usn_work
start with 11gR1
11.1.0.7
defaultro
thanks
and I'll be using CentOs, that should be fine right?
usn_work
Yes, but I'd daresay Oracle Enterprise Linux might be an easier way
And for study purposes, nobody will bother you with licensing discussions I guess
defaultro
oh ok
luisgrin
if i do select * from ALL_USERS; i get some users... but if i do select * from user_tables; i dont see ALL_USERS
usn_work
user_tables has no OWNER column
defaultro
is Oracle Enterprices Linux downloadable from their site and free?
usn_work
because the user is obvious ;)
defaultro, yes
defaultro
cool
« prev 1 2 3 next »