• Changing Server Name Where ORACLE is Loaded

    I was wondering other than to edit the TNS names, would changing the server name andor the IP address where ORACLE is loaded and the data files are located, what other parameters or files do I need to changeedit? Is this doable without too much work? Many thanks, Sam

    SamAvella30 pointsBadges:
  • SECURE FTP SITE ON Windows 2003

    We have a Windows 2003 IIS server setup behind our firewarll which is a PIX firewall. What is the best method to establish a secure FTP site on this IIS server? I have reviewed this topic on the internet and actually talked with somebody from IPSWITCH and the best method available is to purchase a...

    Mconfer0 pointsBadges:
  • please solve this query

    Create Emp table containing an Empno column with the following sample data:- EMP ------- EMPNO ----------- 1 5 9 14 20 25 Write a SELECT statement to display the range of missing numbers. Your output should be as follows:- MISSING ------------ 2 ?- 4 6 ?-8 10 ?- 13 15 ?- 19 21 ?- 24 Don?t assume...

    Sairam170 pointsBadges:
  • problem in installing the second oracle home

    Hi all, Iam having problem in installing the second Oracle_Home to install my SAP Test server , iam already having one Oracle_Home configured which is for my development server on the same box which should not be disturbed. In the Oracle Universal Installer iam giving the Oralce_Home and the path...

    Basis50 pointsBadges:
  • need help in vb code

    Good day, Iam traying to get result of my record as below If next record is biger than previous show "1" If next record is same previous show "1" If next record is smallest show "0" if next record is same previous show "0" Example [CODE] id Time Code Price Res 1 10:00:00 AM 1010 905...

    Rosy990 pointsBadges:
  • Microsoft Access Query Question

    I have created a Database that will create a Resume from Data entered. What I am having problems with are in a Query I have created named "PapersPresented" I have several Authors for One Paper. I want to combine the multiple Authors for each paper so as to eliminate the data redundancy and make it...

    Boggy10 pointsBadges:
  • limit of IN subquery

    what is a limit to use literal values as subquery in IN caluse.

    Vajeem0 pointsBadges:
  • ORA-0942 Table or View Does not exists

    Hello there, I have been running into this error when I create a View based on embedded view and the Schema User has complete permissions on all the objects in question. The environment is Oracle 9i [9.2.0.4.0]. The one thing that distinguishes this view from any other view is that there...

    KALKAJI0 pointsBadges:
  • Visual Basic

    What is the difference between VBA and Visual Basic.Net...I want to learn how to write scripts to automate certain tasks.

    Idapsdst0 pointsBadges:
  • 10G Database Restore to New Server from Backup

    I am a Sr. SQL Server DBA but brand new to Oracle. I have been given a task by my management to perform a backup from our production server and restore it on a brand new server to simulate a disaster. Our environment is Windows 2003 Server and Oracle 10g database. I am having allot of difficulty...

    Sqldatapro0 pointsBadges:
  • ORACLE NOT RECOGNIZING NEW RAM

    We installed more memory on our Windows Enterprise Server but Oracle does not recognize the new memory. I know this because when I select ?host? from Enterprise Manager?s home page the host memory is listed as 2g and it should be 6g. If I try to use the new memory by increasing the sga_max_size...

    Emersokl0 pointsBadges:
  • pl/sql ref cursor question

    Hi, I'm trying to figure out if this is possible in Java OPTION 1 ================== 1. Obtain a ResultSet by querying a non-oracle database 2. Cast the resultSet into an OracleResultSet 3. Pass the OracleResultSet into a pl/sql stored procedure for processing OPTION 2 ================= 1. Obtain a...

    Ajhaveri0 pointsBadges:
  • Automatically Populating a Date Field in a Table

    Can you please forward me an example of a trigger or some other means on how I can update a date field (e.g., DATE_COMPLETED) in a table when another field (e.g., EDITS_COMPLETED) within that same table has been populate with a particular value (YES)

    SamAvella30 pointsBadges:
  • Using LIKE with Variable Value not Literal Value….INSTR not optional

    I'm trying to build a search type select statement constrained by a users input.....variable(x) which forces the use of like in the selection processing: x := (whatever user enters); I have tried with no luck: Select * from personnel where lastname like '%x%'; Select * from personnel where lastname...

    BAdams20 pointsBadges:
  • ora-12154

    I'm new to Oracle so forgive me if I don't have all the terminology down, but I've installed Oracle 10g and I'm constantly getting an "ora-12154 Could not resolve the connect identifier" error at step 12 in database configuration assistant. I beleive it has something to do with the tnsnames.ora...

    Wilson630 pointsBadges:
  • Oracle Application or Database on its own server.

    Which would increase performance more. Moving an Oracle demand planning and forcasting application or an Oracle database onto its own server and or a faster server? There is some debate among myself and a couple of coworkers. I feel that the workhorse of Oracle is the database and that it should be...

    Ktharrell0 pointsBadges:
  • cannot drop the user

    Hi, I cannot drop the user. dorp user "USERA" cascade; ORA-01940: cannot drop a user that is currently connected But when I check v$session table. I do not see any USERA. This happens on me several times and every time when I face this, I need to restart my database. Is there any better method to...

    Cassidy6o60 pointsBadges:
  • HELP : I retrieve a blank page with UTL_HTTP in a request to a server which listen in a different Port than 80

    Dear colleagues I have a problem because a developer form our team, has a problem to retrieve a webpage in Oracle Portal whit UTL_HTTP. If he attempts to retrieve a webpage (pending to Oracle Portal) by a PACKAGE whit the next sentence: URL_TABLE := utl_http.request_pieces(p_website, 99999,...

    Onacorpuscle0 pointsBadges:
  • Running a script at specified runtime

    I am creating an Oracle Developer form which will take the query created by the user and specified runtime (also by user) and saves it in two columns of a Oracle table. Is there a facility in oracle which can trigger off the saved query when the sysdate becomes equal to specified runtime? Thanks

    Columbus0 pointsBadges:
  • Can’t login as Administrator

    Hello Everybody, I can't login to adminstrator profile in my standalone win 2000 adv server. I use this system for my study purposes. What happened actually is when I was shuting my system, it got powered off because of some UPS problem and the next time when I logged in using Administrator, it...

    BinooDas123410 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following