Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. loren256

    unable to open database

    ORA-01207 file is more recent than controlfile - old controlfile Cause: The control file change sequence number in the datafile is greater than the number in the control file. This implies that the wrong control file is being used. Note that repeatedly causing this error can make it stop...
  2. loren256

    how do i delete a database

    Bookouri What type of export file was it that you were trying to import? Was it a full database export? What type of import were you trying to do? What was the command you used? If you have hundreds of pages of errors, there is a high probability that the same error is repeating, what is the...
  3. loren256

    Oracle Not Available

    sounds like you are not shutting it down properly. If you are shutting down your PC every night, you should shut down the Oracle Instance before shutting down the computer. In Windows2000 this is done for you but in NT or other Windows systems you can't be sure so shut it down before turning...
  4. loren256

    question for a simple block...

    Go to URL: http://technet.oracle.com/doc/server.815/a68001/dbms_out.htm Found the following on tech net at the URL above: The DBMS_OUTPUT package enables you to send messages from stored procedures, packages, and triggers. The PUT and PUT_LINE procedures in this package enable you to place...
  5. loren256

    SQL*Loader Control File Generator

    Flat files come in a few pretty standard flavors as far as data layout is concerned. why don't you archive your control files as you write them with descriptive names that describe the data layout of the flat file and then reuse them with a little editing? After a few repititions you will have a...
  6. loren256

    using sql loader for oracle 8i

    Everything you ever wanted to know about SQL Loader is in the document: Oracle8i Utilities Release 2 (8.1.6) A76955-01 Go here: http://technet.oracle.com/doc/server.815/a67792/toc.htm There are six chapters and one appendix and also a syntax guide for using SQL Loader with DB2.
  7. loren256

    Export

    Karluk, I am not as good a guesser as you! You have certainly identified a common problem. Sounds reasonable. I don't think any one expects mistake free tips here. loren256
  8. loren256

    Export

    Dear Schoan, Can't give a quick answer. Not enough info. First, make sure you have specified your parameters correctly for your full export. Then check over your params for your import. Then check those three tables to see what they have in common. I can't understand what you mean by the tables...
  9. loren256

    POPULATING TABLE

    Dear 016, Show us the column names and corresponding datatypes of your two tables, in order. Then one of us will be able to get back to you with an answer. loren256
  10. loren256

    OCP Exam, Intro to Sql and Plqsl , Some Info. pl..

    Preparation for Oracle Certification Exams My personal experience: I used four sources. 1. Couchman's book - DBA Exam Certification Guide 2. The EXAM CRAM series (one for each test) 3. STS.com self test software 4. NETg.com computer based training modules I read the books, did all the...
  11. loren256

    oracle

    Pram: I just found it. The Oracle8i Datatbase has a limit of 512petabytes. You can create up to 64,000 partitions! Ref: Oracle8 DBA Certification Exam Guide, Oracle Press/Osborne, J. Couchman, Chapter 28: Oracle8i Object Administration II
  12. loren256

    cant set up a local instance of oracle 8i on my machine

    If you are setting it up on Windows 2000, go to the control palne/administrative tools/services screen and make sure the OracleService and Listener are started. You can set these to automatic if you have a good deal of memory. Then your instance will always be mounted and open whenever you want...
  13. loren256

    number of OCP?

    You may get this info by contacting Oracle directly. The web page at http://www.oracle.com/education/oln/ lists the following education contact info: Country Web site Telephone North America United States http://education.oracle.com/us/index.html 1.800.529.0165 Canada...
  14. loren256

    SQL 8.0

    Pram, As far as total data storage capacity, I cannot find the exact point of reference but I believe it is 512pterabytes for Oracle8i. On a more practical note, I have the following Min and Max Database limits for you for Oracle8i (ref EXAM CRAM,Oracle 8 to 8i Upgrade,Coriolis,Freeman/Pack)...

Part and Inventory Search

Back
Top