logs archiveIRC Archive / Freenode / #oracle / 2009 / December / 23 / 1
TheBonsai
ha! i love 11g
BACKUP VALIDATE SECTION SIZE .. TABLESPACE ..; works :)
validating the TS with 1,3GB/s
nice..
FANDER
guys please recommend good PLSQL books
I want a book that covers all the concepts, like what's PGA, SGA, instance...etc also covers PLSQL
TheBonsai
for PLSQL you'd need a PLSQL book, for being DBA maybe some DBA classes
i guess a book that covers both is bad in both things
i hate the 'reformat block' hack :) can't they make some ALTER DATABASE FORMAT DATAFILE n BLOCK n?
pfff
Dormir
11g SUCKS!!!
:)
FANDER: you want the concepts, read the concepts manual
TheBonsai
Dormir: i begin to like
*it
FANDER
I'm doing a database course in my university. Our professor is using these slides: http://www.openlineconsult.com/db/intro-db-slides/intro-db-slides.htm
those slides don't belong to a textbook
also the professor adds stuff by him self, like SGA, PGA, instance..etc
also PLSQL
it's just a mess :(
TheBonsai
if you want to learn plsql, you most likely don't care for the database core engine
FANDER
I guess I found a solution (please give me your opinions): for the concepts I'll read like 50-100 pages from this book: OReilly.Oracle.Essentials.Oracle.Database.11g.4th.Edition
for PLSQL I'll use another book
TheBonsai: please check the titles of the slides
TheBonsai
no idea, i learned from a quick 4 day course + many grey hair :D
         

FANDER
any recommended PLSQL book?
TheBonsai
Dormir: do you happen to know a way to reformat a block, beside by foot?
FANDER
I'll use Oracle PL/SQL Programming, Fifth Edition
Bluesea
can i import oracle 10g DMP to Oracle 8i?
TheBonsai_
i seriously doubt that. but you can try
Bluesea
i try it
but failed to import
but ihave idea: replace /bin/imp.exe oracle8i and use /bin/imp.exe from 10g but i dont try it
TheBonsai
is a db link an option?
Bluesea
i dont try ity b4
can u
TheBonsai
well, create a db link and CREATE TABLE AS SELECT * FROM TABLE_NAME@DBLINK_NAME
target database and the username there are specified in the db link
Bluesea
my 10g server is down now i buid 8i server but i have backup 10g DMP
can i import oracle 10g DMP to Oracle 8i server?
TheBonsai
<Bluesea> i try it
<Bluesea> but failed to import
why do you ask? you KNOW it
Bluesea
yes cos i user imp.exe from 8i version
i ask can i use imp.exe 10g to replace imp.exe 8i in my server?
and i import 10g DMP to 8i server
TheBonsai
if it runs, why not? you don't need to replace it, just copy it somewhere. but it will not run, because you need your 10g libraries
and all that stuff
hm
Bluesea
hmmm
ok thx for asking TheBonsai
TheBonsai
i wonder if you can use a 10g client's imp over a network session
you *could* try
from a (full) 10g client
imp foo/passwd@YOUR8iDATABASE ....
but according to docs, the imp version must match the target database version
so... mh... bad idea
amit
hey all
TheBonsai
y0
amit
hows it goin TheBonsai ?
TheBonsai
tired. i'm hunting a few unused corrupted blocks in a 800G datafile :)
but the final verify is running, i think i got them all and can run the clean backup
amit
cool
         

TheBonsai
erm
no :)
it's 04:32
amit
hehe
TheBonsai
and i'm in vacation since yesterday :D
amit
omg!!
i am having hard time even finding a dba job yet lol
just doing some pl/sql stuff for now
and luckily some sql tuning too
TheBonsai
cool
Dormir
TheBonsai: find an answer to your question?
TheBonsai
nope. i did it 'by foot' with the recommended way, just without exception that exits the mass-insert, instead i checked for the block range and write to alert.log when the block was formatted
Dormir
doing it as an exercise?
TheBonsai
ah no heh
i had a corrupt tablespace, 800GB, just 6 blocks corrupt. i reimported the proper object, so the block were unused. but RMAN keeps complaining, of course
our first bigger database systems used buggy adaptec controllers, that didn't report an aborted write operation back as failure to the operating system (and thus to oracle)
so i have at least some practise with this kind of thing :)
Dormir
ah, gotcha
krz
hi
ive got 34tables: tbl_user, tbl_media, tbl_user_media_comment umc, and tbl_user_media_like uml. i want to create a feed out of umc and uml based on the created_at column. should i create a view for this?
Newbie
Difference between 9i and 10g statistics
how to check failed nodes on oracle10g rac
jagadish
sql loader problem
pls help
mator
jagadish, no one is able to help until you can state your problem in details
morning
jagadish
mator:
using sql ldr i want to load say 1million rows
after inserting 1lakh , it operation got failled
next time i want to start from there
how to do it
mator
jagadish, remote first 1 lakh entries and continue?
s/remote/remove/
jagadish
so its not possible to continue from there?
mator
jagadish, did you checked "skip" sqlloader command
?
jagadish
wil try it now
thank you
sidh
greetings gentlemen
mator
ciao sidh
sidh
i'm learning oracle dba and i would like to know if i'm right with this point : when you add several instances, you need one listener per instance , and one different TCP port per listener, is it right ?
djeday
to the point plz =)
mator
sidh, it's usually just one listener for one or many instances
sidh
ok so it is better to manually edit tnsnames.ora to add instance entry, instead of using oracle net configuration assistant that need to stop the listener ?
mator
sidh, http://marist89.blogspot.com/2005/10/setting-up-multiple-listeners.html
sidh
[08:17] <@e^ipi> last time the devmapper repo was touched was a year ago
oops
mator
sidh, also you could get some ideas from http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:387218751430
sidh
mator: that's ok i did as usual i only add tnsnames.ora entries
but my second problem is i don't know how to connect enterprise manager to the new databases, i tried the ?target=NEWDB in the url , but it seems to be wrong
mator
i have almost no knowledge on EM.. try to search somewhere in it how to add abother db... but oracle have another product to control many databases, it is called "grid control"
sidh
ok i finally found
this is the first customer that want oracle on windows machine for his test platform, i'm really not used with that environnement
i'm reading the impdp doc page on http://download.oracle.com/docs/cd/B28359_01/server.111/b28319/dp_import.htm#i1011959 , and i would need to understand one thing : they say it is possible to import database with network link and with tablespaces , but they "The datafiles, specified by the TRANSPORT_DATAFILES parameter, must be made available from the source system for use in the target database, typically by copying them over to the target system.", that mea
funky2
could someone help me with connect_by_isleaf?
Dormir
funky2: ask your question. if someone can help, they will
funky2
I'm using connect by to try and return a hierarchial data. With this data I want to build an HTML Unordered list for a menu on my website. (I'm using ORACLE Application Express(APEX). Now to build it I need to know if there are any children that belong to the parent and if the row is the last child for the parent so I can open and close UL's within a UL.
select rownum, level,CONNECT_BY_ISLEAF , SYS_CONNECT_BY_PATH(link_name,'>'), d.*
from tbl_opt_nav2 d
start with parent_opt_nav2_id is null
connect by prior opt_nav2_id = parent_opt_nav2_id
and start_date <= trunc(sysdate)
order siblings by display_order
Dormir
ok, what's the problem? does that not return what you want?
funky2
some of my connect_by_isleaf returns 1 and some 0. as an example I have two level 2 rows that both have one child. one returns as 0 and the other returns as 1.
Dormir
so it should show 1 for both
funky2
doesn't 1 mean that it is a leaf or 0 if its a branch
Dormir
yes
sorry, it should return 0 for both
funky2
return 0 for both level 2 elements
Dormir
pastebin the resultset
funky2
is there a bit of sql to check the version of 10g that I'm using ?
looks like there is a bug http://forums.oracle.com/forums/thread.jspa?messageID=1271864�
in apex
Dormir
select from v$version
funky2
Oracle Database 10g Release 10.1.0.5.0 - 64bit Production
TheBonsai
10.1 eew
funky2
??
TheBonsai
i have no 10.1 anymore. maybe it's because of RAC stuff, but we were as fast as possible in upgrading to 10.2
Dormir
yeah, 10.1 had quite a few issues
which is why Oracle put out 10.2 so quickly
funky2
I've got another instance that is 10.2 so might see if it works there
TheBonsai
Dormir: (with the same argument they should have pushed 11.x 2 weeks after 10.2 release :) )
Dormir
eh, I haven't had much problems with 10.2
TheBonsai
well, it works. but "hardened software" is something else
okay, the last PSU makes it a bit harder (september 09?)
funky2
i thought if it at least returns whether its a leaf or branch I could put the records into an associate array and do a check to see if the next value was a different level and not a leaf/branch
strange how sqlplus returns the right answer yet sql workshop in apex returns something else
TheBonsai
i just suspect that's the APEX software
funky2
its the latest 3.1.2
TheBonsai
i don't know APEX
that "it's the latest" implies what?
that it has bradnew bugs?
or mature bugs?
:)
funky2
:) mature bugs lol
sidh
i'm trying to impdp a schema trough a network link , so i connect as sysdba on the target database and run my impdp command specifying the source schema and the remap_schemas option (inorder to create the user on the target DB), but i get an error : "ORA-39149: cannot link privileged user to non-privileged user
TheBonsai
try as system
what's the target user of the db link?
sidh
but i checked twice, the user of source DB has EXP_FULL_DATABASE privileges
in fact the target user does't exist yet, i want impdp creates it
TheBonsai
the target user of the database link
you have a db link
it's either CURRENT_USER or some existing user
how did you create the database link you're using? what's its DDL?
sidh
oh sorry , in my mind, i impd from a source DB to a target DB, so the network link use the 'cimaise' user
for creating the db link i connect as sysdba and typed :
create database link cimaise_cimtest connect to cimaise identified by password using 'cimtest';
i meant i connected as sysdba on the target DB
TheBonsai
i suspect (i just suspect) it has something to do with the sys as sysdba you do the exp as
create a public db link or a system's, then try it as system
i'm not sure about the role EXP_FULL_DATABASE either, but unless you want to export another user than cim it shouldn't really matter
sidh
so i drop my existing db link first and recreate a new one as system
TheBonsai
well, you don't need to drop, since your db link belongs into the SYS schema, the other one will be in SYSTEM. or you just drop and CREATE PUBLIC DATABASE LINK
sidh
TheBonsai: i created the db link as public, and used the system user of the target db to do the impdp parfile=myparfile.txt, and i still get the error
TheBonsai
A Data Pump job initiated be a user with EXPORT_FULL_DATABASE/IMPORT_FULL_DATABASE roles specified a network link that did not correspond to a user with equivalent roles on the remote database.
does that match?
sidh
http://arkzoyd.blogspot.com/2008/01/importer-des-donnes-avec-data-pump-sans.html <= Exemple 1
it creates the target user
TheBonsai
i don't get it. you have a system A, you want to import a schema from system B, schema BUSER, yes?
also useing BUSER to connect to the database
also using BUSER to connect to the database B via db link
it should be as easy as impdp system/foo network_link=my_dblink_for_b_using_buser schemas=buser
i only do such stuff as SYSTEM, maybe that's why i never have to fiddle with such weird messages
but anyways, you don't need EXP_FULL_DATABASE role to export your own schema
(i mean SYSTEM on both sides)
sidh
TheBonsai: i really don't understand, enterprise manager told me cimaise user has exp_full_database privileges, but i did as sysdba, grant exp_full_database to cimaise; again, and then it works
TheBonsai
well, that's what you get when you use anything else but the database
oracle tools are... oracle tools. the database is genious, the rest is average+
sidh
now my imdp fails because some tablespaces doesn't exist in the new schema so i will check the documentation to see if it is possible to "import" the tablespace too
TheBonsai: you confirm what i thought, that is why i'm learning the command line way,
TheBonsai
remap_tablespace exists in datapump
but it can't create one
because a tablespace doesn't belong to a schema
sidh
yes after reading the doc for half an hour, i realize TABLESPACES option, is not for importing tablespaces, but let you filter tables per tablespace, instead of a user schema
thanks a lot TheBonsai
TheBonsai
y0
« prev 1 2 next »