ORA-00904 invalid column name and export
Hi! I'm doing export across network. Export is started on Linux server containing 8.1.7.2 enterprise edition install. Target db is 8.1.7.0 enterprise edition residing on WinNT. This is what I get at the end of export log . exporting job queues EXP-8: ORACLE error 904 encountered ORA-00904: invalid column name EXP-0: Export terminated unsuccessfully What the hell is going on? Is there a way to avoid this? If there is no way, anyway I would like to know what is going on... Thanks, Vladimir Barac -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-00904 invalid column name and export
Title: RE: ORA-00904 invalid column name and export 1. No enough space for exports... 2. All exports are on some large drive (linux box) from where exports go to the tape... 3. No f!$^% decent shell scripting available on NT... - Original Message - From: Richard Huntley To: Multiple recipients of list ORACLE-L Sent: Tuesday, July 16, 2002 3:13 PM Subject: RE: ORA-00904 invalid column name and export Vladimir... I'd suggest starting the export on the target, the 8.1.7.0 installation. HTH, Rich -Original Message- From: Vladimir Barac - posao [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 8:08 AM To: Multiple recipients of list ORACLE-L Subject: ORA-00904 invalid column name and export Hi! I'm doing export across network. Export is started on Linux server containing 8.1.7.2 enterprise edition install. Target db is 8.1.7.0 enterprise edition residing on WinNT. This is what I get at the end of export log . exporting job queues EXP-8: ORACLE error 904 encountered ORA-00904: invalid column name EXP-0: Export terminated unsuccessfully What the hell is going on? Is there a way to avoid this? If there is no way, anyway I would like to know what is going on... Thanks, Vladimir Barac -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Yesterday's date - unix question
Good morning / afternoon / evening... How to find yesterday's date in unix? Yes, I know how to find it by using env. variables, sql*plus, redirecting output and so on... But I need pure unix solution. Thanks, Vladimir Barac -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-600 during replication
Good morning / afternoon/ evening (depending on your position)... Alert log has following lines... Tue Jun 25 10:07:30 2002 Errors in file E:\Oracle\admin\vurs\bdump\vursSNP2.TRC: ORA-12012: error on auto execute of job 123 ORA-12008: error in snapshot refresh path ORA-00600: internal error code, arguments: [ktbdchk1: bad dscn], [], [], [], [], [], [], [] ORA-06512: at SYS.DBMS_SNAPSHOT, line 617 ORA-06512: at SYS.DBMS_SNAPSHOT, line 674 ORA-06512: at SYS.DBMS_IREFRESH, line 577 ORA-06512: at SYS.DBMS_REFRESH, line 211 ORA-06512: at line 1 What the hell is going on? I tried to do some search on metalink, but to no avail. Hate to say this, but it is kind of urgernt! Regards, Vladimir Barac -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Activating replication
Hi Oracle 8.1.7 EE both Win2000 and Solaris Is running catrep.sql really, really, really all that is needed to activate replication in 8i?
Re: Activating replication
Well, I was thinking about replicatin related sys-owned procedures only!!! Actual data replication is on behalf of my own planning, of course! I don't expect catrep.sql to quess my thoughts and do job instead of me! Regards, Vladimir Barac - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 01, 2002 4:53 PM not even close read the docs... all that running catrep does is load the stored procedures you will need to use. You need to decide on multi-master vs materialized view replication if materialized view: read-only, updateable, writeable synchronous or asynchronous and that's just to determine which kind of replication you want to be running. Then you actually have to implement it. Rachel --- Vladimir Barac - posao [EMAIL PROTECTED] wrote: Hi Oracle 8.1.7 EE both Win2000 and Solaris Is running catrep.sql really, really, really all that is needed to activate replication in 8i? __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Locked rows - finding out
Hello listers By quering V$LOCK or V$LOCKED_OBJECT I may find which tables are locked. How do I see rowids of rows that are locked? And how do I see into what rollback segment is being used by transaction that placed locks on those rows? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Unix related - need some info
Good day to everyone... I have two questions related to Linux and Solaris... * I need do find memory usage (physical, virtual...) of a particular proccess. PID is given by by ps, but what aditional parameters I have to provide? At a first glance, output of man ps vas confusing... * How do I find computer's configuration - what CPU, numbers of CPUs, clock, amount of memory, number of harddrives, what version of OS, what OS patches are applied...? No, I can't ask sysadmin about that (hard to explain), and, no, I don't have any kind of advanced manuals... Thanks in advance, Vladimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Sites worth visiting
For those who don't know yet... www.oracle-base.com www.oracledba.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Unix shell scripting - cool link
For those who already don't know, go to the site listed bellow. http://www.injunea.demon.co.uk/index.htm Great tutorial that deals with shell scripting.
Num. of blocks multiple of 5?
Hi all!I have created tablespace where initial and next extents are same = 128KB.Block size is 4K.After creating test table and querying DBA_SEGMENTS, I see that new tableoccupies 35 blocks, instead of 32 blocks.Same happened with tablespace where initial = next = 256 and test tableoccupied 65 instead of 64 blocks.Why is this happening?Regards
OT: X Win client
Hi all! Is there any free (important: free) X client software for NT? Regards, Vladimir Barac
OT: Sybase
Question for dual - dbms dba people. Beside Oracle, I have some Sybase stuff to do. And I'm sure that there are some of you that do know something about Sybase. Do you have any documents that deal with: - tricks'n'tips - do's and dont's - introductions - backups - best practices - worst practices... Feel free to send either docs or links. Thanks in advance, Vladimir Barac -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ITL, DELAYED BLOCK CLEANOUT
Just curious... Could someone shed some light on INTERESTED TRANSACTIONS LIST and DELAYED BLOCK CLEANOUT?Thanks