Discussions
Categories
- 382K All Categories
- 2.1K Data
- 207 Big Data Appliance
- 1.9K Data Science
- 447.5K Databases
- 220.8K General Database Discussions
- 3.7K Java and JavaScript in the Database
- 24 Multilingual Engine
- 518 MySQL Community Space
- 464 NoSQL Database
- 7.8K Oracle Database Express Edition (XE)
- 2.9K ORDS, SODA & JSON in the Database
- 475 SQLcl
- 3.9K SQL Developer Data Modeler
- 186K SQL & PL/SQL
- 20.9K SQL Developer
- 292.8K Development
- 7 Developer Projects
- 125 Programming Languages
- 289.5K Development Tools
- 95 DevOps
- 3K QA/Testing
- 645.5K Java
- 23 Java Learning Subscription
- 36.9K Database Connectivity
- 150 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.8K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 16 Java Essentials
- 143 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 197 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 245 LiveLabs
- 36 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.8K Other Languages
- 2.3K Chinese
- 166 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 225 Portuguese
Sample Schemas - sh.costs table rows not inserted
Hi All,
I am trying to install all the sample schemas provided by Oracle.
Everything gets installed fine but only the rows in sh.costs table is not getting inserted.
The error in the log file says:
Edit 2: I got the above error when I ran the @mksample script while keeping teh sh connection open in SQL Developer. When I closed all connections and ran the script again, I got the following error:
Please help! I need this table for usage.
Thanks in advance
-Apoorva
Best Answer
-
The problem is resolved!
I dropped all the schemas, set oraenv again and then ran @mksample script.
This created all the schemas without any error.
Thanks for all the help
Answers
-
Hello, have you tried to rebuild the SH.TIMES_PK index?
-
HI,
It turns out that the error is different.
I got the above error when I ran the @mksample script while keeping the sh connection open in SQL Developer.
When I closed all connections and ran the script again, I got the following error:
-
So is this a SQL Developer issue? I.e., is the $ORACLE_HOME environment variable set?
-
Bug 21179055 - EXTERNAL TABLE PREPROCESSOR DOESN'T WORK IN WINDOWS
-
Are you running the correct scripts? The ones in your OH/demo/schema won't work, you have to download them from github.com. This is in the docs.
Incidentally, I;m always surprised when I see Oracle staff asking for help on the public forum. When I worked for Larry, I would have died of embarrassment before doing that
-
Hi,
Of course! I have downloaded the latest files from GitHub.
Also, I don't see why one should be embarrassed to seek help and learn. I am not I hope you grow out of such psuedo-prestige.
Thanks
-Apoorva
-
Hi,
I am using Linux. Also, I have given rwx permissions to all folders in the sample schema.
-
No, I am running the script from SQL*Plus.
Yes, $ORACLE_HOME is set.
-
-
The problem is resolved!
I dropped all the schemas, set oraenv again and then ran @mksample script.
This created all the schemas without any error.
Thanks for all the help