31. august 2011 - 12:55Der er
6 kommentarer og 1 løsning
Why do I get systemtables from Oracle?
Hello!
I'm playing around with some code that retrive metedata from an oracle.
I have created a tablespace and a user like: DROP TABLESPACE testing INCLUDING CONTENTS AND DATAFILES; CREATE TABLESPACE testing LOGGING DATAFILE 'C:\testing.DBF' SIZE 32M AUTOEXTEND ON NEXT 32M MAXSIZE 2048M EXTENT MANAGEMENT LOCAL;
CREATE USER testing_user IDENTIFIED BY testing_password DEFAULT TABLESPACE testing;
GRANT CREATE SESSION TO testing_user; GRANT CREATE SEQUENCE TO testing_user; GRANT CREATE PROCEDURE TO testing_user; GRANT CREATE TABLE TO testing_user; GRANT CREATE VIEW TO testing_user; GRANT UNLIMITED TABLESPACE TO testing_user;
In this database I got a table like:
DROP TABLE Countries CASCADE CONSTRAINTS; CREATE TABLE Countries ( id INT NOT NULL, name VARCHAR(255) NOT NULL, PRIMARY KEY (id) ) TABLESPACE testing;
When I try to fetch the tables like: String[] types = {"TABLE"}; ResultSet resultSet = databaseMetaData.getTables(null, null, "%", types);
I dette særtema ser vi på, hvordan cloud og AI bliver fundamentet for virksomhedernes digitale forretning, og hvordan de nye muligheder for automatisering og forretningsværdi kan udnyttes uden at miste overblik, sikkerhed og menneskelig kontrol.
At least in the first line I do it like sys (creating the user) could this be something? (But correct me if I'm wrong when I say that I hardly can not create the user since I do not got any other user to use?)
In the second command I use the newly created user to set up the tables.
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.