Databases :: Increase The Database Size In Oracle Manually?
Jul 7, 2010Can anybody tell me how can I increase the size of the database in oracle manually.
View 2 RepliesCan anybody tell me how can I increase the size of the database in oracle manually.
View 2 RepliesI'm working with Oracle database and I want to improve performance of my website.I read about caching. So is it possible to implement caching (SQL Server Database Dependency) with oracle?
View 2 Replieshow i can use Oracle database with asp.net mvc 2 web application?
View 3 Repliesaccording to the developer of the web service I am calling.He said "bump up the default values for the following":
maxBufferSize="4096000"
maxReceivedMessageSize="4096000"
Where can I put these to bump them up? I've tried googling these settings, and I get sections of web.config that I don't have. I don't have a WCF client, either. Does this make sense to do from my web service, developed in VS 2010?
I'd like to just call his service without changing anything, get the error, and then go from there. I'm even getting that far because I got some other exception saying server was unable to process request, but it had nothing to do with exceeding a buffer size.
i am inserting a record into oracle database using vb.net,there is a password field by using md5 i am generating it and taking tht value as string(ex: "16D78A6B10D631C8C86397C35A3CCD57") now my requirement is i should insert it into database(oracle) & in database that field is "RAW" how to do this?and the error msg is
Type of value has a mismatch with column typeCouldn't store in Col_Pass Column. Expected type is Byte[].
i hv been trying to perform insert operation on Oracle 10G database using asp.net 3.5. So far i m new to oracle and i m confused as back end queries seems different froms sql server. this code is in submit button click event:-
[code]....
I'm a little confused as to what is causing the following error is a very simple application: System.ArgumentException: An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB The code-behind has this:
OleDbConnection conn = new
OleDbConnection(ConfigurationManager.ConnectionStrings["db_conn_qa"].ConnectionString);
In the Web.Config, the following is present (note the Provider is clearly there):
<configuration>
<appSettings/>
<connectionStrings>
<add name="db_conn_qa" connectionString="Data Source=xx;Persist Security Info=True;User ID=xx;Password=xx;Unicode=True"
providerName="System.Data.OracleClient" />
</connectionStrings>
<system.web>
...
am trying to insert images into oracle database using c#.net.but am getting error "ORA-01465: invalid hex number".Here is the code.
if (FUcontrol.HasFile)
I have to automate one database process in .Net web applicaiton which uses Oracle 11g Database as Backend.
I need to know two things:
(1) How to check space on Oracle database server? I need space on server and not in the Database itself. My process creates few tables so I want to make sure that we have sufficient space before the process starts.
(2) Also I need to create script to backup Indexes and Triggers on the table so that I can recreate them after data transfer process is completed. Any idea how to create script form c# code?
How do I read excel(with many worksheets) using asp.net c# and load the data into oracle database?
View 2 Repliesam in deep trouble with retriving the data from oracle database. Please HELP ! In one line: "When i retrive the data from oracle database, it's truncate the data if it is more than 4 kb"I have oracle proc param as below:
PROCEDURE p_GetData (
ivar_id IN id_n%TYPE,
oclb_owners OUT CLOB,
onum_sqlcode OUT NUMBER,
[code]...
I am developing an web application using csharp and oracle as database. I have table with columns like below. How can I ensure that sql selects from one table column but it shows two columns depending weather it is Debit or credit. How can I come up with something Statement of Account ?
Number Amount Type
2 6000 Dr
3 4500 Cr
4 2300 Dr
5 1200 Dr
6 1300 Cr
Now I want the sql out put to be as below. How can I achieve?
NUMBER Dr CR Balance
2 6000 1000
3 4500 5500
4 2300 3200
5 1200 2000
6 1300 3300
I am trying to insert values into oracle database using visual studio 2010 express edition. find the below code I used:
[Code]....
We have an Oracle 11g database with two nodes. On occasion, one of the nodes goes down and for some reason one of my applications starts throwing this exception:
Error Message: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because
all pooled connections were in use and max pool size was reached.
at System.Data.OracleClient.OracleConnectionPoolManager.GetPooledConnection(String encryptedConnectionString, OracleConnectionString options, OracleConnection owningObject, Boolean& isInTransaction)
at System.Data.OracleClient.OracleConnection.OpenInternal(OracleConnectionString parsedConnectionString, Object transact)
at System.Data.OracleClient.OracleConnection.Open()
Out IT group says that this is a program bug because the failover isn't working, but I am thinking that this is a function of the database.What is the cause, and if it is an application bug, what can be done code-wise to fix this problem? The connection string doesn't specify a particular node.
I have one desktop application which is maintain all information related to laws of high court. we have stored lots of data in my application and now
our database size is almost 40 GB.
So my application runs quite slow.
How can i reduce the database space on my hard disk.
I have .Net web application which connects to Oracle 10g database. I want to check for space availibility before creating Indexes. Also if space is not sufficient then I would like to send an Email message to admin. How to do that from .Net web application?
View 2 RepliesI have a table in orcale database where I am inserting records. I am able to insert a record in a table but it is not being saved permenantly.When inserting there is no error. what could be causing this?
View 4 RepliesIs there a way to increase the size of the box of a Checkbox
View 4 Repliesis there a way to increase the maximum 10 GB size limit of SQL Express? http://www.microsoft.com/express/Database/http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx
View 3 RepliesMy WCF service working fine when my dataset table contain less no rows...
When the DataSet tables contains large data then it gives error like this..
I am using MasterPage and using using a CSS in master page. My problem is in its content page, I have a messgage box comes up in some condition resulting FONT SIZE INCREASE. I do not have any font specification in my content page. I do not know how my content page font size change when I click on "OK" to my message box.
View 3 Replieshow to increase size of Immediate window by default in vs 2010 Professional?
View 1 RepliesThe values are stored in viewstate fr the postback... Does everysubsequent post back increase the viewstate size?
View 1 RepliesIn my web page I have lot of validation controls. These controls emit some script block to the page, that increase my page size
Is there any way to put that script in to separate js file need client validation also.
I have master page in that I have header for the child pages, in the child page content populated in the table as row and colum. The problem is when the content in the childpage expand horizotally then when I scroll to right side horizontally the header of the master page doesn't render same size as the content page.
heade remain the size of the windows but not same size as the content page's content.
how can I increase the size of header which is rapped in the div at the runtime.and the backgroung of the div is the image which is coming from css.
Below is the markup of master page.
<%@ Master Language="VB" CodeFile="Results.master.vb" Inherits="Results" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
<title>Results</title>
<link rel="stylesheet" href="css/style.css" type="text/css"/>........