Search results for query: *

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...

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...

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...

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...

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...

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.

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

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...

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

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...

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

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...

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...

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)...