Oracle EXECUTE privilege not granted on DBMS_LOCK,Synonym DBMS_PLUGTS doesnt exist

I am trying create a database in oracle 9i with (username, pwd) as "system & oracle"I got following error:Checking for existence of required packages...PASSED: Package DBMS_JOB existsPASSED: Synonym DBMS_JOB existsPASSED: EXECUTE privilege granted on DBMS_JOBPASSED: Package DBMS_UTILITY existsPA ...

Oracle import + PLS-00201: identifier 'DBMS_PLUGTS.NEWTABLESPACE' must be declared

I have took an transport_tablespace export successfully..( in Linux )while doing an import ( in windows ), i am getting the following error.=======================================IMP-00003: ORACLE error 6550 encounteredORA-06550: line 1, column 7:PLS-00201: identifier 'DBMS_PLUGTS.NEWTABLESPACE' mus ...

DBMS.CODE=-444 Error

what is this DB2 error DBMS.CODE=-444 ...

I find that dbms cannot maintain consistence only by logs recording.

if creating a tablespace using "file system caching"option, then when dirty data is being flushed,it is actually being transfered into the filesystem's cache,but from the dbms' standpoint, the data has been wrote to the disk and will be there even sometime later the system be crashed. if a ...

I doubt the performance(and/or usefulness) of solid(Main memory DBMS).

Although it was came from IBM. I couldn't accept the performance(and/or usefuleness) of solid.http://www.solidtech.com/en/carrier-grade/index1.aspMy issues for advantages of solid are.....0) It cost some 10 sousand dollers adding to cost of DB2(or other DISK based DBMS).1) If it was so high performa ...

Limitations of SQL7 desktop DBMS?

what are the limitations of the DBMS? ...

Oracle erreur système détectée

Lorsque j'entre mon mot de passe, il y a une erreur système détectée ...

Translating DBMS

How can I translate the DBMS objet that Oracle uses for its dynamic cursors ? ...

DBMS maintained views

Some time ago I was working with DB2/400 - and one of the most appreciatedfeatures was the concept logical files - a bit more than views in that theymaintained an access path. That is it maintained an index of the records inthe physical table(s) depending on specified view selection criteria -includ ...

MySQL Is Oracle still the no. 1 dbms in the world?

Is oracle still the no. 1 dbms in the world? all the web-site databases i have seen are using MySql, and i suppose most big company will go on line, right? but how come oracle still the no. 1 dbms? ...

Bulk inserts between two different DBMS

I have a table located in DB2 nd I need to have a mirror image of this table on a SQL2000 database to avoid some server downtime problems. Right now I have a solution using ADO.NET with Windows Services. This windows service invokes itself everyday morning and pulls all the records from this table i ...

structure of DBMS

hiIn a drawing of DBMs there are three type of input, i was wondering are these input known as Schema modification, Queries and Modifications and wat do they meancan anyone one explain the structure of DBMS or know an article in this ...

[SQL 2005 Express] Synchronizing data with non-Microsoft DBMS, possible?

I am thinking of implementing a few kiosk based machines that generate data and store them in SQL 2005 Express.At the cut off date of everyday (End of day), I need to collect back these data and store them in a centralized DBMS sitting on a server.Is it easier to do it with SQL 2005 enterprise editi ...

DBX - SQL queried XML DBMS in PHP

Hi, and though this might seem like self propaganda, I really think people might be interested in this:A friend of mine and I have come up with a PHP script that we call DBX, and it is a small scale Database engine.What's cool about it is that it's a small(<20k) DBMS, and it takes in basic SQL qu ...

MySQL Erreur code 1064

Bonjour, Je suis débutant en MySQL et je viens de MSSQL. J'ai écrit la procédure suivante: DELIMITER $$ CREATE PROCEDURE ClientAdd(IN @Nom varchar(50), IN @Prenom varchar(50), IN @DateNaissance date, IN @NoRue INT, IN @Rue varchar(100), IN @ComplementRue varchar(100), IN @CodePostal varchar(5), I ...

what is Default DBMS application in MAC? (like ms access in windows)

What is default DBMS system in MAC. Also is there any way to develope dbms application in windows and run that file on mac os.In short which is the dbms software which which can work on both mac and windows platform? ...

"DBMS" My SQL inquery

I want to have any information related to these criteria about My SQL, please?1. DBMS Name (the original name if any)2. Manufacturer3. Year of Production4. Version (last version)5. Number of Users 6. Performance7. Cost 8. Size in Hard Disk9. Interface10. Memory11. Compatibility12. Software Developme ...

Choosing a DBMS

Im building a web application, which will be deployed for a small area (City) expect 20,000 or more records across 15 or so tables, for a trial period, if successful, it will be launch nationwide (NZ) maybe 200,000 or more records. Im trying to determine which DBMS, I should use, I have a very limit ...

Oracle line break out of SQL Command, or dbms.put_.line

Someone a idea??I've a varchar2 column, let's say varchar2(200). How can i format the output:a) on the command lineb) using pl/sql (dbms.put_line)to contain a line break after some amount of characters or words printed (including blamks), and not hav a stream of characters in the output? ...

Migration to DBMS

Is there any documentation available for migration from DB to DBMS like Oracle ? ...

Documentation for migration from DBMS to RDBMS

Is there any general documentation availalbe for migration from DBMS to RDBMS ? ...

Oracle DBMS Version 6.1 Reserve Words

Is "report" a reserve word for DBMS Version 6.1? ...

Dbms And Rdbms

hican any one explain the diff between dbms and rdbms using an example like emp and dept.I could not understand properly. ...

Cost Models for relational DBMS

I need to calculate the costs of different queries evaluation in a relational DBMS. Thus, I would know if there are generic cost models based on I/O and CPU for each type of queries ? ...

DBMS information "Oracle"

I want to have any information related to these criteria about Oracle, please?1. DBMS Name (the original name if any)2. Manufacturer3. Year of Production4. Version (last version)5. Number of Users 6. Performance7. Cost 8. Size in Hard Disk9. Interface10. Memory11. Compatibility12. Software Developme ...

Oracle ORA-29855: erreur d'exicution de la routine ODCIINDEXCREATE

When i try:create index mon_index on mes_docs(text) indextype is ctxsys.context...the result is:ERREUR ` la ligne 1 :ORA-29855: erreur d'exicution de la routine ODCIINDEXCREATEORA-20000: ConText error:ORA-06520: PL/SQL : Erreur pendant le chargement de la bibliothhque externeORA-06522: Unable to loa ...

cannot see result in dbms output

i am running a store procedure and except to see the result in the dmbs output tab.i see the message set serveroutput on in the output tab but i cannot see the results after running the storeproceduredo i need to enable the dbms output ...

Extract SQL statements from the old sybase DBMS (10.0 or 11.5)

HiI'm a newbie to Sybase. I was assigned a task to migrate the databases in the old sybase version (10.0,11.5) to the current Sybase version or extract the sql statements from the data device files (.dat). And the old DBMS cannot be on the running-time states becasue we don't have the DBMS rec, whic ...

IBM DB2 MySQL to DB2 Comparision DBMS white papers

I am curious as to the capabilities of MySQL as an enterprise DBMS and how it compares to DB2 regarding performance, scalability, ease of management, support…the whole gamut. Can you respond with personal beliefs and experiences that anyone there has regarding the subject including any large clien ...

DBMS IN9 64-bit is not supported in Pb8

a client has recently upgraded to IN9 64-bit and now a powerbuilder 8 (32-bit) application can't connect to the informix server. an error encountered reads: 'DBMS IN9 is not supported in your current installation' How can i make it work without upgrading PowerBuilder application? ...

How can i connect from w2k to VMS Oracle DBMS

anybody an idee? How can i connect from w2k to VMS Oracle DBMS.thx for your helpSpassi ...

Number of DBMS Platforms supported

I would like to find out how many DBMS platforms other companies are supporting. Other info I am interested in include: - are your DBAs centralized or decentralized (work in & for appl teams)?- is the design/development DBA functions combined with production DBA functions (backup, recovery, tuni ...

Ingres II r3 - Installation done. No dbms?

I downloaded ingres II r3 for solaris 9 and installed as per instructions...had a few issues with variables, directories etc - but all sorted now and ingres will now start with no errors...but - there is no dbms server and when I go into cbf there is no dbms listed to configure - see below:System Co ...

I doubt the performance(and/or usefulness) of solid(Main memory DBMS).

Although it was came from IBM. I couldn't accept the performance(and/or usefuleness) of solid.http://www.solidtech.com/en/carrier-grade/index1.aspMy issues for advantages of solid are.....0) It costs some 10 sousand dollers adding to cost of DB2(or other DISK based DBMS) and needs additional server( ...

DBMS modelling techniques

Explain the different types of modelling technoques used in the development of current DBMS.. ...

DBMS has a UTF8 character set

I'm installing Optim 7.1 for oracle Database, and I'm configuring the first Workstation. When indicating target Database ,I receive the following error :The Unicode Setting for the DB Alias does not agree with the DBMS. If the DBMS has a UTF8 character set, ensure that the Optim Unicode option is se ...

Platform Independent DBMS, get integrate in Applcation.

I have a java application that is been used on windows, solaris and hp-Unix.I need to access a File with One Million Records in it. In starting i used.CSV for storing and retrieving records.But now a DBMS is required to read the data, obviously.The DBMS technology should be included in the Applicati ...

ProfileStage Invalid repository specified (unrecognized DBMS

I am trying to connect to the Southbreeze tutorial text fileswhen I start ProfileStage I choose the DSN i have createdODBC DSN Logon is configured to an Ascential TextFile (*.*) driveri use UID sa and when i click connect I get ProfileStage Invalid repository specified (unrecognized DBMS) error whet ...

Perl and an MM DBMS

Can somebody please suggest a good main memory dbms which has a perl-cgi interface, i.e, which can be used in a perl cgi program? ...

Optim 7.1.1 & Oracle Express 10.2: Connection String or DBMS Documentation

I'm installing a fresh Optim 7.1.1 and face this issue when configurating Optim. On Connect to DB dialog, I try to input many possible Connection String but it doesnt work. There is always an error:«Unexpected response from internal component, RC:-1External Code:230 PN0DSQR0A Connection String is r ...

Oracle Where can I find DBMS system commands

Where can I find the references about DBMS system commands like dbms_stats.get_table_stats? ...

Oracle Where can I find DBMS system commands

Where can I find the references about DBMS system commands like dbms_stats.get_table_stats? ...

Oracle where can I find DBMS related system commands

Where can I find the references about DBMS system commands like dbms_stats.get_table_stats? ...

[multivalued DBMS] How can I make this SELECT?

This is my first post on this board, so excuse me for my poor english and if I'm not respecting any rules here.I have a problem to make a query that seems simple tough.There is only one table:Products:id (int) 1:1 unique and indexedname (string) 1:1manufacturers (int) 1:n multivaluedI want to select ...

Recommended DBMS for standalone Java Application

We are planning on using VA for Java -windows platform - to develop a standalone database application. We want to include the database with the application installation and are looking for suggestions on which DBMS to use. I have heard of Cloudscape and Pointbase but am wondering if there is a versi ...

Oracle DBMS JOB

I would like to run a procedure in the background. When the user presses a button from the front end application, I don't want the user's cursor hung while the procedure is running. I want the control back to user and when the procedure finishes flash a message or something. I know we can run on uni ...

Oracle DBMS vs unix Cron job

We have a web application using Oracle 8.1.7. When the user enters a process button on the web we want to run the procedure in the background and we also have some jobs that needs to be run in a scheduled time. My dba is telling us to use cron in place of dbms job. He thinks it is easy to maintain. ...

Oracle URGENT:unix shell script or a DBMS job

I have to do the following :in UNIX1. pick up all files in the directory (ie:ls)2. for each data file one by one i run sql loader3. i delete/move the filewhat is suggested? a unix shell script or a DBMS job?thanx for the reply *if possible can i know how to run os command for 1&3 step above,in o ...

Oracle DBMS JOBS

I am running dbms job and I want this job to run everday at midnight. Any one know how to set the next interval.I can insert record in user_jobs table using dbms_job.submit(vjobid,'procedure name;',sysdate,sysdate +?);I just don't know what to use for this interval? ...

Recommended DBMS for standalone Java Application

We are planning on using VA for Java -windows platform - to develop a standalone database application. We want to include the database with the application installation and are looking for suggestions on which DBMS to use. I have heard of Cloudscape and Pointbase but am wondering if there is a versi ...