To which Tablespace the user System be attached to ????




Should the user System be attached to the System table space or is it advisable to attach it to some other.

Please suggest.


Also whats the difference between sys and system.

I know sys is the super user but what is system.

Posted On: Thursday 15th of November 2012 09:18:28 PM Total Views:  419
View Complete with Replies

RELATED TOPICS OF Oracle PROGRAMMING LANGUAGE




how can I show duplicate records which appear inside 1 table which don't appear in another table

I would like to find out if there are duplicate records inside a table which only appear once in another table (NOTE: this is different to finding out if the record doesn't appear at all). e.g. tbl1: ID | SURNAME 01 | Smith 02 | Jones 03 | Smith tbl2: ID | SURNAME 248 | Smith 249 | Parker 250 | McCall 251 | Ali 252 | Singh 253 | Jones The SURNAME 'Smith' appears in the first table twice :- I would like a query to tell me if any SURNAME appears in tbl1 more than it does in tbl2 (as they should appear the same amount of times). Here's what i have so far, but this results in showing me both the records in tbl1. SELECT tbl1.SURNAME, tbl2.SURNAME AS NewSurname FROM tbl2 INNER JOIN tbl1 ON tbl2.SURNAME = tbl1.SURNAME results in: SURNAME | NewSurname Smith\t\t \t | Smith Smith\t\t\t | Smith So the result I am looking for is to see ONLY the erroneous record - (in this case only 1 Smith, so I'd like to see only 1 record). NOTE: For ease of understanding I have substituted the field name for 'surname' but it's actually something more unique like a security number which i'm searching for, but the principle is exactly the same - as this could appear twice too.
VIEWS ON THIS POST

221

Posted on:

Wednesday 7th November 2012
View Replies!

Procedure Espects Parameter which was not supplied

I have the following code to fill a dataset Dim cn As New OdbcConnection(ConfigurationManager.ConnectionStrings("csSybaseGuille").ConnectionString) \t Dim da As New OdbcDataAdapter \t Dim ds As New DataSet \t Dim var As String \t cn.Open() \t With da \t .SelectCommand = New OdbcCommand("pb_polizas_usuario", cn) \t .SelectCommand.CommandType = CommandType.StoredProcedure \t .SelectCommand.Parameters.Add(New OdbcParameter("@nro_doc", OdbcType.VarChar, 20, "nro_doc")) \t .SelectCommand.Parameters("@nro_doc").Direction = ParameterDirection.Input \t .SelectCommand.Parameters("@nro_doc").Value = nro_doc \t var = .SelectCommand.Parameters.Count \t var = .SelectCommand.Parameters("@nro_doc").Value \t .Fill(ds) \t .Dispose() \t End With Dim cn As New OdbcConnection(ConfigurationManager.ConnectionStrings("csSybase").ConnectionString) \t Dim da As New OdbcDataAdapter \t Dim ds As New DataSet \t Dim var As String \t cn.Open() \t With da \t .SelectCommand = New OdbcCommand("pb_polizas_usuario", cn) \t .SelectCommand.CommandType = CommandType.StoredProcedure \t .SelectCommand.Parameters.Add(New OdbcParameter("@nro_doc", OdbcType.VarChar, 20, "nro_doc")) \t .SelectCommand.Parameters("@nro_doc").Direction = ParameterDirection.Input \t .SelectCommand.Parameters("@nro_doc").Value = nro_doc \t var = .SelectCommand.Parameters.Count \t var = .SelectCommand.Parameters("@nro_doc").Value \t .Fill(ds) \t .Dispose() \t End With I always have this error: Procedure pb_polizas_usuario expects parameter @nro_doc, which was not supplied. It works if a do the following: With da \t .SelectCommand = New OdbcCommand("pb_polizas_usuario '123456789'", cn) \t .Fill(ds) \t .Dispose() \t End With But I dont want in this way. What can I do.
VIEWS ON THIS POST

248

Posted on:

Wednesday 7th November 2012
View Replies!

Alternative to TOP which supports also Oracle?

Could anyone please tell me how to write below query without using the keyword TOP. because I would need to execute same query in both oracle and SQL Server. Oracle does not support TOP.
VIEWS ON THIS POST

251

Posted on:

Wednesday 7th November 2012
View Replies!

Accessing the stored procedure which takes 2-3 hours to complete!

Hi ! iam accessing oracle stored procedure which takes lot of time to completethrough asp.net . if the session drop between the execution of SP thanSP stops can any one help me in this regard that if session drop between the execution of SP than SP will not stop it will execute in background!
VIEWS ON THIS POST

249

Posted on:

Wednesday 7th November 2012
View Replies!

LAST_INSERT_ID() on which Connection?

Hi Folks, I would like to use the SELECT LAST_INSERT_ID()statement i MySQL to get the last auto-incremented id. The documentation says: the most recently generated ID is maintained in the server on a per-connection basis. It is not changed by another client. My Questions is what is considered a connection.... each time my web sever connects to the mysql sever it's considerd a different connection correct I't's a different connection even if it comes from the same web server Even if in Asp.net the connection has the same name i.e (Dim myConnection2 As New MySqlConnection(connectionString2)) Will different instances of the above connection example be considered as different connections by MySQL If different sessions of my web application are all connecting to the MySQL db with the above connection definition each session will be considered as seperate connection by MySQL What I'm concerned about is if somehow my different web sessions use the same connection and therefore it would break the logic of the SELECT LAST_INSERT_ID() and one user would fetch another one's ID...
VIEWS ON THIS POST

221

Posted on:

Wednesday 7th November 2012
View Replies!

oracle or sql...which is better????

dears i have a simple doubt...oracle or sql, which one is more powerful database\t...i am beliving oracle software is morebetter than sql ...i used sql2005 only...no any touch with oracle...
VIEWS ON THIS POST

207

Posted on:

Wednesday 7th November 2012
View Replies!

which datatype takes actuall value

in my database i gave a datatype as float so i entered a value as 3.10 but it taking as 3.1 and also i entered as 3.999 but it will taking as 4 how its possible which datatype store the actuall value ex : if i entered as 3.999 means it will as 3.999 only again if i given as 3.10 means it will take as 3.10 only
VIEWS ON THIS POST

217

Posted on:

Wednesday 7th November 2012
View Replies!

How to call a SQL function which returns a cursor using c#

Hi i am new to .net. Can someone please advise how to call a SQL function which returns a cursor using c# i have tried to call using OracleCommand.CommandType = CommandType.StoredProcedure OracleParameter p_case_action_id = new OracleParameter("@p_case_action_id", OracleDbType.Int32); p_case_action_id.Direction = ParameterDirection.Input; p_case_action_id.Value = intSourceID; orlCmd5.Parameters.Add(p_case_action_id); but it's throwing an exception saying invalid arguments or saying the function name is invalid i even tried to call the function using CommandText rather than storedprocedure and the result is same errors Function -------------- FUNCTION get_student_data(studentid IN NUMBER) RETURN case_cursor;
VIEWS ON THIS POST

501

Posted on:

Wednesday 7th November 2012
View Replies!

which is better?

hello I have a big database that queried all the time... i have a little search engine on my web page. the queries really only need 30 columns of the db... there are about another 15-20 columns that hold other information not distinct to queries... Question is: Would it be better for me to create two databases, one with 30 cols and the other with 20\t or just leave it how it is... all in one db\t Thank You Ryan
VIEWS ON THIS POST

224

Posted on:

Wednesday 7th November 2012
View Replies!

connect to mysql or sqlserver with a class which has parameters for both

i have a aplication which need to connect to 2 database (one on mysql and other on sql server) , and i decide to make a class in a dll which will have some parameters to the constructor , from which will depend the type of connection... have anyone of you something like that\t......have ideas how to succed with this..... you think that i could or not to finish this... help me. thx a lot
VIEWS ON THIS POST

300

Posted on:

Wednesday 7th November 2012
View Replies!

myOleDb & myOdbc. which one is better for asp.net?

myOledb->olebd.net myOdbc->odbc.net Someone asked me which is the best one(less bug pronne, speed, etc) to use in asp.net
VIEWS ON THIS POST

147

Posted on:

Wednesday 7th November 2012
View Replies!

Win 7 64 bit dev machine, Win 2K3 32 bit production box, Oracle 10g which clients do I need to run?

As the title says I have a Win 7 64 bit dev machine, Win 2K3 32 bit production box and I run against Oracle 10g whichOracleclients do I need to run Do I need to run the Oracle 32 and 64 bit clients And if so what versions
VIEWS ON THIS POST

292

Posted on:

Wednesday 7th November 2012
View Replies!

How to Read an open Excel File which is updated Continuosly

How to Read an open Excel File which is updated Continuosly. I have to read data from an excel file which is updated Continuosly on another server and it remains open all the time. Please suggest me the right way to proceed.
VIEWS ON THIS POST

305

Posted on:

Wednesday 7th November 2012
View Replies!

How to call a SQL function which returns a cursor using c#

Hi i am new to .net. Can someone please advise how to call a SQL function which returns a cursor using c# i have tried to call using OracleCommand.CommandType = CommandType.StoredProcedure OracleParameter p_case_action_id = new OracleParameter("@p_case_action_id", OracleDbType.Int32); \t\t\t\t\t\t\t\t\t p_case_action_id.Direction = ParameterDirection.Input; \t\t\t\t\t\t\t\t\t p_case_action_id.Value = intSourceID; \t\t\t\t\t\t\t\t\t orlCmd5.Parameters.Add(p_case_action_id); but it's throwing an exception saying invalid arguments or saying the function name is invalid i even tried to call the function using CommandText rather than storedprocedure and the result is same errors Function -------------- FUNCTION get_student_data(studentid IN NUMBER) RETURN case_cursor;
VIEWS ON THIS POST

179

Posted on:

Wednesday 7th November 2012
View Replies!

which trace should I use?

Hi all, I have an application running reports against my oracle database. That app is connecting to the database using ODBC data source. I'd like to trace the sql statement used by the reports. How can I do that I've tried to enable the client trace(set trace_level_client=16). It worked but there is no fun to read the trace file (and it's so hard to catch the actual sql statement since there are tooo much other info over there). I also thought about enable user-level DBA tracing. But since that user will have a new SID and serial# each time, I can't do this either. Any idea on what's my other options are TIA...
VIEWS ON THIS POST

159

Posted on:

Monday 12th November 2012
View Replies!

which is the next rollback segment?

hi, is there any way to find which rollback segment will be alloted for the next transaction -Raja
VIEWS ON THIS POST

256

Posted on:

Monday 12th November 2012
View Replies!

which index will be faster ?

Hi , I have doubt in index. Which index will be faster getting the data Index given separately for empno, location, job OR Composite index like (empno,location,job).
VIEWS ON THIS POST

200

Posted on:

Monday 12th November 2012
View Replies!

which grant to give

I got 2 database and i want that the user in database 2 can modify a table of a user in a database 1 ex : Database1 : user1 table1 Database2 : user2 user3 There is a public database link from Database 2 to Database 1 It connect to databse 1 by using the user2 I want that the user user3 can modify table1 of user1. I try : grant delete,insert on user1.table1@database1 to user3 but it's doesn't work. Could someone helpme. May I have to create a view which privilege may i have to give to user3
VIEWS ON THIS POST

266

Posted on:

Monday 12th November 2012
View Replies!

which document?

which oracle document should i take a look in order to know the meaning of all latches i checked oracle 8i references, it only have all the information about wait and statistics information.
VIEWS ON THIS POST

143

Posted on:

Monday 12th November 2012
View Replies!

which clause is correct?

which clause of the RECOVER MANAGED STANDBY DATABASE command specifies an interval of time to wait for a specified archived log file to be written to the standby control file's directory 1) FOR 2) WAIT 3)TIMEOUT 4)WIRTE_WAIT
VIEWS ON THIS POST

150

Posted on:

Monday 12th November 2012
View Replies!