|
|
|
|
|
|
|
|
Re: Restore [message #563180 is a reply to message #563179] |
Thu, 09 August 2012 06:16   |
 |
Littlefoot
Messages: 21760 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
You need to create a new user, then connect as it (newly created user) and start creating tables.
Here's a short walkthrough:
SQL> select tablespace_name from dba_tablespaces;
TABLESPACE_NAME
------------------------------
SYSTEM
UNDOTBS1
SYSAUX
TEMP
USERS
SQL> create user brisime identified by bri
2 default tablespace users
3 temporary tablespace temp
4 profile default
5 quota unlimited on users;
User created.
SQL> grant create session, create table to brisime;
Grant succeeded.
SQL> connect brisime/bri@ora10
Connected.
SQL> create table my_first_table (col date);
Table created.
SQL> insert into my_first_table (col) values (sysdate);
1 row created.
SQL> select * from my_first_table;
COL
-------------------
09.08.2012 13:16:12
SQL>
However, I think that you should read some documentation first. Although you are on 11g, have a look at this 10g documentation page - its "Getting started" section is what you should read (Concepts first, then 2 day DBA). After that, go to SQL Reference. These should make a good starting point for you.
[Updated on: Thu, 09 August 2012 06:17] Report message to a moderator
|
|
|
|
|
|
|
Re: Restore [message #563288 is a reply to message #563200] |
Sat, 11 August 2012 04:17   |
 |
oracle@learner
Messages: 73 Registered: October 2011
|
Member |

|
|
Should I have to create the user test in new oracle 11g or simple i have to put the imp command.? The following message comes..
Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Users\Administrator>e:
E:\>cd d
The system cannot find the path specified.
E:\>cd Backup
E:\Backup>imp test/test fromuser=test touser=newtest bufffer=2097152
LRM-00101: unknown parameter name 'bufffer'
IMP-00022: failed to process parameters, type 'IMP HELP=Y' for help
IMP-00000: Import terminated unsuccessfully
E:\Backup>
Thanks!
[Updated on: Sat, 11 August 2012 04:55] Report message to a moderator
|
|
|
|
|
Re: Restore [message #563295 is a reply to message #563288] |
Sat, 11 August 2012 09:27  |
 |
Littlefoot
Messages: 21760 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
oracle@learner wrote on Sat, 11 August 2012 11:17
E:\Backup>imp test/test fromuser=test touser=newtest bufffer=2097152
LRM-00101: unknown parameter name 'bufffer'
IMP-00022: failed to process parameters, type 'IMP HELP=Y' for help
|
|
|